Error Trapping

[Guest]

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.

 

[Guest]

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

 

[onedaywhen]

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).

I sometimes appreciate getting immediate feedback e.g. in WinXP
Explorer when I type an illegal character for a folder name the
character is immediately removed and I get a balloon tooltip, 'A
filename cannot contain any of the following characters...'

I also appreciate when the fact that one form control's value is
dependent on another is handled before I hit the 'Apply' button e.g. if
the choice is one or the other then I'd expect to see two option
buttons rather than checkboxes.

Jamie.

--