Access query question

[stuartkeith]

Its been about 6years since doing any database work and i didnt do any advance searches.

What I am trying to do is search information and make reports based on critera entered into a form!

So I have a search form setup to allow the user say enter the colour of the item. he can then if he wants choose the size of the item.

Then he clicks serch and a report is generated with all the items that are blue and in the size requested.

I know I need a query and report setup as well as the form! I have the form setup, but am unable to workout how to make the query use the information entered into the form for the search results!

[sdkfz]

set the criteria up on the query to point to a form - in the criteria row of the query under the field the criteria applies to

[Forms].[Your Form Name].[your text box with the criteria typed in name]

the form will have to be open of course so set up the report via macro to pop the form, then have another button to kick off the macro part two that runs the report and have it close the form once the report is generated.

your macro sequence would be something like:
part one
open form [your form name]

part two
run query(ies) pointing to form
run report
close form [your form name]

You can do this better with VB but I'll have to leave that to some one better at this than I