Report Based on Form?

[jbruno]

I would like to create a report based on criteria selected on an unbound form. I have never tried this before. Can this be done and if so....

How do you link the report and the form together?

Do you need to make a query based on the form first and then run a report off the query?

As always, I appreciate all the great help and advice given by you guys.

 

[Chris RR]

If you are using Access tables, this is pretty simple. You create a query that picks up its criteria from the form. In the "Criteria" row in query design view, you'll have something like this:
=[Forms]![fMyForm]![Report_date]
Where fMyForm is the form, and Report_date is some field on that form. Remember that your form will need to be open while you run the query (but it can be minimized).

Then you base your report on that query.

If you are using ODBC and linked tables, the query part gets more complicated. There's Microsoft Knowledge Base article on it (Q131534).

 

[jbruno]

Thank you very much for the help! I tested it out and it works!