Parameter Form for Report

[FJ Questioner]

I have a report based on a query that has a Parameter form as a criteria.

I copied the report and the query and changed the query criteria to
reference a new parameter form. If I run the new query and enter the
criteria manually it creates the correct info. However when I open the new
(ie copied) report, the parameter form that shows up is NOT the new one
referenced in the new query criteria but rather the original form from the
original report I copied.

How do I get the new report to use the new paramter form referenced in the
criteria of the new query? I thought that once the new form was listed as a
criteria in the new query it would automatically pop-up but apparently not.

Its been a long time since I did any Access work so I'm hazy on this. I'm
sure its something very simple to fix.....

Thanks,
FJ

 

[Damon Heron]

??? Call the report from the open Parameter form with a command button.

Damon

 

[Allen Browne]

Here's a simple example of what Damon is suggesting:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Here's another example:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
Method 1 is what you are currently doing; Method 2 is what Damon suggests.

 

[FJ Questioner]

Great. Thanks. (I've now got your website in my Favourites!)