Thanks, Rich

I certainly will.  It's great to get a leg-up when you need one.

Best wishes

Paul

Thanks, Rich

I admire your in-depth knowledge. 

I'm going to make the change you suggest - as I now understand why I am doing it.

Excellent help....

Many thanks again

Paul

Thanks Rich

I have two combos on a small form which allows students to be chosen by either FirstName-LastName or LastName-FirstName.  A double-click on the unique ID then adds the student...

Thanks, Martin

Good advice.

Paul

Thanks everybody for excellent comments.

Thanks Rich for your very complete reply once again.

It seems from this that I can use the combo loading all records - without causing undue network...

Thanks Remi

OK, I'll stick with what works.

It's all working well thanks to your help - once again.

Best wishes

Paul

Thanks, Remi

That works great.

However, the problem isn't quite solved.

I have been putting the combo's Recordsource code in the On Open event of the form, not the On Click event of...

Hi

OK will do.

I said yes I'll change the list, but I think I am getting something wrong.

I have changed the sp fine.  That will now work on a letter.  However,...

Thanks, Remi

I'll make the change.

Also, if I have a table for a subform and have it linked by Master and Child fields to to the main form - does this...

Thanks again Phil

This is another good idea.  However, the content of the field is not consistent and would not lend itself to this.

Paul

Thanks, Chris

I am trying to do near-as-possible sort as some of the values in the field don't conform to an actual Day.

Paul

Thanks, Padmaja

Absolutely right.  Somehow I just couldn't spot it.  It now works a treat.

Thanks, Phil

Fascinating code.  I'll give it a work through.

Many thanks again to you both

Paul

I have been saved by the new mdb dodge several times before......

The left function is great and I'll find it very useful. 

Everybody's helfulness makes this an excellent site.

Many thanks

Paul

Hi Mike

Absolutely right.

The Wuaueng.dll reference was showing as missing??  The file was there and I just had to remove then reinstate it.  All is now working great.

Many thanks

Paul

Thanks Dornig

This works a treat....

The only small fly in the ointment is that Microsoft Spyware tries to stop it and asks whether to Accept or Abort Registry modification.

However, this is...