Error Trapping

K

Kirk P.

I'm trying to account for all possible errors related to the selection (or in
this case the non-selection) of an item in a combo box. When the user tabs
past the TranType control, I've got a MsgBox in the Exit event notifying them
they must make a selection in TranType. It works, but let's say the user
dismisses the MsgBox, then just wants to close the form. It pops the error
message 6 times, to which the user must click OK on each one, then closes the
form.

Is there a better way? Maybe the event I've chosen to fire this MsgBox is
incorrect.
 
M

mscertified

I find it's usually a better user interface to validate all input at the same
time just before the record is to be updated (BEFORE UPDATE event). Of
course, you should also have a CANCEL button so the user can exit without
saving the record and without any validations being done.

Dorian
 
Top