Discussion Locked

Searching records MS ACCESS

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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)

1 reply

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.