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
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