I have a form that updates a record in a table. The form has two comboboxes. Combobox #2 depends on Combobox #1. If I change the value in CB#1, CB#2 turns blank and you have to select a new value. If I then click on the UNDO button, CB#1 reverts to the original value but CB#2 reverts to blank and not the original value.
CB#1 is based on a Value List
CB#2 is based on a query.
Undo Button logic
Private Sub CmdUndo_Click()
Me.Undo
End Sub
I have tried for hours to get this to work and I have had no luck. Based on everything I read, I should just be able to code "Me.Undo" and the data should revert to the original values.
Any help would be greatly appreciated.
Thanks.
Sandy