Updating tables using forms
After creating the search and results pages, you create links on the results page to open the update page.
The search and results page let users retrieve the record and the update page lets users modify the record.
There will be times that you will only want to see the records that match the criteria that you are searching for.
In this case, you can use the Filter option instead of the Find option.
For more information, see Create links to the detail page.
After the results page passes a record ID to the update page identifying the record to update, the update page must read the parameter, retrieve the record from the database table, and store it temporarily in a recordset.