Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.As you proceed, remember that updating data is not the same process as entering new data.The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment. You can use the Refresh method to view changes that have been made to the current set of records in a form or datasheet since the record source underlying the form or datasheet was last refreshed.In a Microsoft Access database, the Refresh method shows only changes made to records in the current set.
However, on the front-end form the user can still edit previous records.
Users will enter some search terms and see a datasheet view of the results in a subform.
The prod table is linked (the form is not included in the production mdb file). Display Form to show the search form and unchecked "Display Database Window". I expect the average user to have very limited knowledge of Access.
For information about entering new data in a database, see the article Add one or more records to a database.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.