Forms and queries and reports oh my

[Meijhana]

ack.

I am trying to make a form that will allow a user to enter in their search parameters, press a button, computer searchs the master table, creativly entitled All Items, to find records that match all of the criteria. The user can enter any where from 1 to 10 different search parameters. I want them to be able to narrow down their search by adding more criteria. I also want it to display a table in a sub form to show the results and then be able to print the results in a report.

Currently I have a form where they can enter in the search criteria but all the spaces keep bringing up the information in the different records. if my user enters anything it will either change a record or start a new one.

I am just learning access so any help would be appreciated. Thanks

Meij

 

[giuliani22]

Meij

I would suggest making a Make Table Query with parameter queries for the fields that you want the user to filter for.

The Access help function does a pretty good job in describing the specifics on how to do this.

-Ben

 

[giuliani22]

I forgot to add... You can create a command button (from the toolbox on the toolbar) on your form to run the make table query.