error message disapeared ?

J

JulieD

i have a number of forms that are based on tables with required fields in
them - however, if i enter a record into the form and don't fill in one of
these required fields, on closing the form it just closes without giving an
error message about the required field and none of the record is saved.

i can't figure out what i've done to make this happen.

using access 97

Regards
julieD
 
J

Jamie

Have you used DoCmd.SetWarnings False at some point?

Try DoCmd.SetWarnings True and see if that helps.

Jamie
 
J

JulieD

Hi Jamie

thanks for this, i can't find DoCmd.SetWarnings False anywhere in the code,
i tried DoCmd.SetWarnings True in the beforeupdate code of the form, but it
didn't seem to work :(

cheers
julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DMax on existing record to increment serialized # fails 1
Why don't I get an error message? 9
Updateing data when closing forms 3
Bound continuous form with required fields - problem copying & pas 4
required fields 5
Error on closing a form 4
Required field added to existing records 12
Form for Parts-Tools Lists 0

Top