Searching records MS ACCESS
On my switchboard I have a "View Existing Order" button.
How do I make it:
1. Open a FORM
2. Let user type data in a field to search
3. Then search for that record (using a search button on form)
Web Development
On my switchboard I have a "View Existing Order" button.
How do I make it:
1. Open a FORM
2. Let user type data in a field to search
3. Then search for that record (using a search button on form)
by glenda gable
First of all.. did you use the Wizards to create the database? In other words, did someone create, or did Access generate the database?
If someone created the DB, then it is easiest to use the wizard to create the command button to open the form.
Basically an easy way is to:
1) Create a query from the table you want. Make sure to include ALL the fields you want to include on the form.
Under the "Criteria" under the particular field you want type a parameter (enclosed within brackets) for the user to search. For example if it is a date enter [Enter the date]
This will make the query a parameter query and the user must type in the exact criteria to run the query.
2) Create a form from the query. When the form is opened, it will automatically prompt for the information (as per the parameter query).
3) Create a command button (make sure the wizard button is depressed). The wizard will take you through the steps of using the button to open a form. (It's under "Form Operations" - and then choose the form from the list provided)
If Access created the Main Switchboard, then you will have to play with the design of the switchboard, but the same process will work. The reason you have to play a little bit with it is that the switchboard automatically creates more buttons that arent viewed until they are "activated" by making them "do" something.
If you need further help, just email me.
- Glenda
This discussion is closed to new replies.
Sort by Trending