error message disapeared ?

  • Thread starter Thread starter JulieD
  • Start date Start date
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
 
Have you used DoCmd.SetWarnings False at some point?

Try DoCmd.SetWarnings True and see if that helps.

Jamie
 
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
 
Back
Top