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
