Most forms validate new and modified records and report validation errors. The system displays messages about any field that contains an invalid value or about any field that requires a value but does not contain one.
EXAMPLE: One such validation error is a faulty date entered in a date field. If the field requires a date after today's date and you enter an earlier date, the system displays an error message.
The validation procedure occurs, and any error messages display, when you:
To check records for errors, perform any of these actions.
Some fields are set to validate immediately and not wait until you perform one of these actions. In these cases, validation occurs as soon as you attempt to move the focus to another field in the same record.
When you perform an action, other than an action to save all records, that triggers validation, the system displays an error message for the first field in the current record that contains an error. If there are multiple errors, the system then cycles through each field with an error.
If you attempt to save a form that has multiple records with errors, the system reports which records in the current collection contain errors. You cannot save the form until all errors have been corrected.
To correct the current record:
The insertion point moves automatically to the field containing the error.
To correct records in the collection:
Repeat the entire procedure until you have corrected all records indicated in the error message from the save operation.
Some forms are designed to report warnings and other information in a dialog box. The dialog box opens when you attempt to save records. Use the dialog box to troubleshoot and correct the problems:
To close it, Click Done.
To reopen it, from the View menu, select Warning Messages. The messages remain available for viewing until you refresh the collection or perform another save operation.
About Adding, Changing, and Deleting Records
Copying Data To/From a Spreadsheet