G
Guest
Boy do I need help. I have a combo box on a form, cboSAR_ID. Based on the
value the user enters in cboSAR_ID I populate many other text boxes and list
boxes on the form. If the user enters a different value in cboSAR_ID--no
problem--I can handle that. If the user hits the "Esc" button and undos the
cboSAR_ID entry, I want to give a warning and then if the user wants to undo,
then I need to clear all the other fields. If the user chooses not to undo,
I want to put back the value in cboSAR_ID.
This sounds simple enough, but I have tried entering code in the Undo,
BeforeUpdate and AfterUpdate events of cboSAR_ID (those events are not
triggered with "Esc").
The Form_Undo event is triggered, but that event is triggered when any
control is cleared. How can I check to see if it was the cboSAR_ID control
that the user chose to undo?
Thank you for any help you can give me,
Judy
value the user enters in cboSAR_ID I populate many other text boxes and list
boxes on the form. If the user enters a different value in cboSAR_ID--no
problem--I can handle that. If the user hits the "Esc" button and undos the
cboSAR_ID entry, I want to give a warning and then if the user wants to undo,
then I need to clear all the other fields. If the user chooses not to undo,
I want to put back the value in cboSAR_ID.
This sounds simple enough, but I have tried entering code in the Undo,
BeforeUpdate and AfterUpdate events of cboSAR_ID (those events are not
triggered with "Esc").
The Form_Undo event is triggered, but that event is triggered when any
control is cleared. How can I check to see if it was the cboSAR_ID control
that the user chose to undo?
Thank you for any help you can give me,
Judy