Combo Box problems

[EddyLLC]

Is there a means to preserve the data in a combo box so if it is accidently changed I can reset it?

For example, if a combo box has "Jones" in it and the user uses the pull down to review other names but accidently clicks on "Smith" I have code, a msgbox calling the users attention to the change but if they do not want to change to "Smith" how can I reset the combobox to "Jones"

I tried putting the contents of the combo box into a variable but seems all the Event procedures occur after the new data, "Smith" is loaded into the combo box thus the variable holds the new data not the old. Even the Before Update event.

Any help is greatly appreciated.
Thanks

 

[jebry]

Hi!

If the combo box is bound to a field in a table then there should be a .OldValue property which holds the original value until the AfterUpdate event of the form is performed.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst