Updating Existing Records
The Form tool can be used to scroll through the records of a table, examining each one by one in a user-friendly interface. This is accomplished by pressing the Find Prev and Find Next buttons or by using the vertical scroll bar.
If you come across a record with incorrect information, you can update the field and press Enter to commit the new data to the existing record.
Searching for Records
To place the form in search mode, press the button labeled Criteria.
This allows us to enter a myriad of search criteria and have the form return and display only records that meet that criteria.
Example 1: If we enter “James” in the Person field and press Find Next, we can step through and view each record that begins with the word “James”.
Example 2: If you wish to locate ALL records that contain the word “James”, you can employ wildcards to broaden the qualifications. By entering “*james” you will discover all records that contain the word “james” regardless of position.
Example 3: You can also use relational operators to discover records, such as “>” greater than, “<” less than, “=” equal to, etc…
If you wanted to locate all records from a specific date, you could enter something like “=1/1/2019”. If you wanted to locate all records with a salary greater than or equal to $100000, you could enter “>=100000”.
NOTE: If you accidentally alter a displayed record and you wish to revert to the original record information, click the Restore button. This assumes you have not pressed ENTER and committed the data to the table. If that occurs, you can fall back and use UNDO to restore the information.