best way to check fields before saving?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi,

Using Access 2003 here.

What's the best way to check if all the necessary fields have data
before trying to save the record (in order to avoid cryptic ODBC or
Access error messages)?

The validation rule of the control isn't enough it seems since it only
gets activated if the user has at least entered the field once? But the
user could try to say before all the mandatory fields are filled out.

Thanks.

Jerome
 
I find the best way is to not bid your controls to your data. For example,
don't have your text boxes based on a field. Then add a Save button, and in
this check that all the data is ok before updating your table.
Diarmuid
 
Ok, but this means you have to code everything (from the connection to
the DB to checking the fields to actually save the data) yourself, right?
 
Yes. It seems like a lot of work, but its not that bad once you start it. It
makes your data entry screens a lot more flexible as well. No more half
finished records, left when the user went to lunch.
 
ok, thanks!
Yes. It seems like a lot of work, but its not that bad once you start it. It
makes your data entry screens a lot more flexible as well. No more half
finished records, left when the user went to lunch.
Click to expand...
 
Back
Top