Update another table

[mous]

Access 2000.

I have a data entry form that before the user selects another record (via a combo box) or the user clicks the save button I would like to be able to populate another table.

Basic e.g.

If the user leaves one or more mandatory fields blank on the form I want to update / append another table in the database (unknown to the user) based on a unique record number this error.

i.e. If the user leaves Field1Missing = 1 after they click the Save button my another table 'tblValidation' field 'Field1Missing' is updated with a 1, so that I can produce a validation report at the end of the record, records or day?!?

Thanks

 

[jrjr]

If the field is mandatory, why not just make them fill it out? Don't let them leave till the form is complete.

 

[mous]

I don't want to do this. I have other checks also.