Want to revert to original entry when editing combo box

[psbsmms]

I have a routine that changes several items on the record and for external pictures, I want to put in a option after the user changes the combobox to revert back to the original choice. i have a message box asking if the really want to change in the on change event and if they select no i want to put the comnbo box back to the original choice.

 

[JoanneM]

You could use .oldvalue

eg if if msgbox reslt = no then me.comboboxname = Me.comboboxname.oldvalue
checking to make sure that null values can be accepted by this field or you will generate and error

hoep this helps

jo

 

[psbsmms]

Thanks that worked well.