I have a work MS Access database which my boss has asked me to enhanced. I am quite new to MS Access so would like people's input. The database has a form and a table and each record has a unique identifier. Users will go into the form and fill in details (sometimes some fields do not get updated) Once the user puts the details in, it gets saved into the table.
Now here is the question. My boss has asked me to enhance the database so that users can retrieve the record using a form by doing a search on the identifier and then amend the fields which they have left off.
So I need the database so somehow bring (or auto fill the details) that has already been updated and then enabled them to amend the details so the database needs to do the following
- Users can retrieve a record by doing a search on the Identifier so the record of the identifier appears on the form
- Users can amend the form and details
- User saves and then table gets updated
My database is very simple so I hope someone knows how to do this