Creating an Access Search Form

[Icky_Joe]

I'd like to be able to create a form that allows me to perform a name search. First, I want to enter the name, then click on a button to return the record. I also would like some additional fields (address) to pull up when name is found. Is this doable? If so, can one of you experts help an access novice achieve this task.

[jzwp11]

There are several ways to do this, but let me ask a question first. Is the name and address information in the same table? Do you have an autonumber primary key field in that table? If so, then I would create a form bound to that table using the form wizard. Save the form. Now create another new form. This form should not be bound to any table. On that form add a combo box (using the combo box wizard) that is based on the table that holds the name/address information, select the primary key field (it should be the first field) and the name information you want to see in the combo box. Now, using the command button wizard, add a button to the form that opens the first form you created (form operations-->open form). After selecting the first form you created, click next. You should be presented with a choice to either "Open the form and find specific data to display" or "Open the form and show all records". You want the first option. You will then use the primary key field that will be supplied by your combo box.

[fanzak]

You can base the form, that you wish to be filtered, on a query whose results are restricted (in criteria row) to the value of a control from the main form.