I now need to use my form to show only certain records from my table. (duh)
I don't know how to a: question the user for input for the query.
and b: input the query results into my form.
Haven't found that info anywhere yet.
thanks IA for any direction signs.
-Fred
Certain records? What is the field name and criteria?
There are several ways to do this.
Here is a very basic generic method.
Create a query that returns all of the fields you will need to display
on the form.
As criteria on, for instance, the LastName field, write:
[Enter the last name]
Save the query.
Make this query the record source of a form.
Whenever you open the form, you will be prompted to enter the Last
Name you are wanting to display.
A better method is to create a form that displays all of the fields
you want to see.
Set the table as the form's record source.
Add an unbound combo box to the form's header.
Use the Combo Wizard and select the 3rd item on the first page of
questions, something like "Find a record ... etc.."
Complete the wizard.
When done find the name in the combo box and select it.
Those records will be displayed on the form.
