help with a search function / switchboard

sambucaman

Registered User.
Local time
Today, 13:26
Joined
May 6, 2010
Messages
41
Hi everyone,

Im relativly new here, Ive only been using access 2003 for a while (and, btw, finding it very hard to get my head around! :confused:)

Ive so far created a fairly basic db, with table and a form; with names, addresses, contact numbers, appointment dates etc.

How do i create a "search" box, so I can tap in a surname, or an address and get a list of results?

Ideally this would be in the form of a switchboard (is that the right term?) so that when i start the database I get a small window, with a few options on ie "New Customer" and a "Search" and maybe a "reports" button as well.

The most important option to me is the seach function, if anyone can help id be very gratefull.

thanks

Andy
 
There are probably about a half dozen different ways you can search for a record in Access. Here is the simplest.

Create a query that controls the form that displays the searched for record.

Create a new blank form with one unbound text box. With the form in design view, click on the properties of the text box. The text box should have been assigned a name by Access. In this case we'll assume the assigned name is Text2.

Save your form giving it a name you'll remember.

Open the query in design view. In the criteria of the query for the field you will be searching on enter:

[Forms]![FormName]![Text2]

Go back to your original form and place a command button to open the form that will display the record when it's found.

Open the search form, enter the data you wish to search for, click the button. The display form should open with the desired record displayed.
 

Users who are viewing this thread

Back
Top Bottom