I am sure that this is on of those things that is too easy, that is why I am having trouble. I have a form with a sub-form to hold sales order info. On the form there is a combo box for "Order Type". This controls what types of items are available to be ordered. If the user changes the “Order Type” combo box I check if there are any records in the sub-form. If there isn’t, I allow the change without any trouble. If there are records in the sub-form I open a message box with YES/NO buttons and ask if they really want to delete the records in the sub-form. I can deal with the YES option. The NO option is causing the problem. I have all of my code in the Before Update event. I can set Cancel = TRUE and it does not write the record, but it doesn’t revert the combo box back to the original value. What is the VBA code that does the same thing as the ESC key? I don’t know what to call that so I am having trouble looking it up.
Thank You,
sabloomer
Thank You,
sabloomer