Forms

S

sewerboss

How do I put a text box in to do a search on my form, such as I have many
last names and want a box to type in one name and cause the db to find all
the same names?
 
N

NetworkTrade

Sometimes Access doesn't always give you some things the way one expects.

If you have multiple tables then you would want to create a Form and subForm
using the Form wizard.

If you are working within a single table then what you might want to
consider is first creating a Parameter Query. Make a Query and in design
mode for the name field put this in the Criteria line [Enter Name]

When you press the ! you will then get this prompt i.e. Enter Name....and
it will return all records for that name...

Next just go ahead and create a new Report and in the wizard select that it
be based on this new Parameter Query.....
 
Top