MsgBox vbCancel - Combo box.Undo

[Dan Artuso]

Hi,
Have you tried:
CboCompany = 89
??

HTH
Dan Artuso, Access MVP

 

[Carl Grainger]

I have a combo that has a default value of 89 - "Select Company"). If a user
selects value 90 - " Add New Company", and then selects cancel from the
resultant message box, I need the combo to reset to it's default value of
89. At present it remains on value 90.

The MsgBox uses vbOKCancel and I have used the following in a number of
variants, but nothing happens (not even an error msg):

Case vbCancel
CboCompany.Undo

Is it because the combo is based on a query? If so how can I reset the
combo, without a requery on the whole form?

Any help would be most appreciated.

Regards cg

 

[Carl Grainger]

No I hadn't. and it works a treat.
You're the man Dan.

Regards