Update event not triggered

  • Thread starter Thread starter Thomas T
  • Start date Start date
T

Thomas T

How can I stop the user from closing the form when a required field is left
blank (null).

I have a table with one required field, (the field is set to required in the
table and there is no default value) and some optional fields. I have a
simple popup form that lets the user create a new record, fill in data and
close the window with a wizard close command button. From previous work with
access i expected to get an ugly error message when the user leaves the
required field blank and tries to close the form. But this does not happen.

Instead no new records are inserted into the table, the afterUpdate event
does not fire, there are no error messages, but the autoindexnumber is
incremented.

I really need help on this one! Thanks,

thomas
 
I resolved the error myself...

Access help states that the DoCmd.Close statement does not trigger any errors.
 
Back
Top