Record Validation

H

hughess7

Possibly a simple one but...

I have a form in data entry mode which allows a user to create a new record
and then close the form. Several fields require validation etc and this is
set at the table level. Access has stopped prompting the user that required
fields are blank and instead just closes the form but does not save the
record. This is a problem as the user is not aware that the record was not
saved.

Is there an option somewhere to toggle this or has any one any idea why it
has stopped prompting the user that the record will be lost if the form is
closed?
 
J

Jackie L

Did you turn off your warnings? This can happen if you have code to turn
warnings off and then not add the code to turn back on at the end, or if the
code crashed in the middle, the warnings would not be reset.
 
H

hughess7

Thanks, I did think of that, ran a macro to turn them back on just in case
but didn't make any difference.
 
Top