MS Access Record Search and Form Population
Posted on 2007-07-25
I'm running an Access db in a multiuser environment . I need to create a command button that will allow end users to search for a specific record that populates a form that I have already created.
1. Open database, "menu" form is loaded by the startup
2. User completes the form
3. User notes the ID number (primary key) and needs to have the capability to go back to just that record.
4. I would prefer that the user can simply type in the ID # into a text box field, it looks up the specific record and populates a form.
Please provide me with the code to perform this (command) operation and tell me the best way to implement.