paramter query works but report doesn't

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know I must be missing the silliest mistake but I have checked and
re-checked and cannot find my error. Being a first-timer, I followed the
instructions for "Create a form to enter report criteria" in Help.

I have set up a parameter query, the form to enter the parameters (dates), a
macro and a report. If I open the query, it asks me to enter the dates and
then pulls up the correct records so, I think a portion of what I've done is
correct. However, when I open the report, it opens the form, I enter the
dates and get a blank report. Any ideas where the mistake might be? Thanks
in advance.
 
The flow should be:
1.Open form, the form containing the parameters shuld have a button that
opens the report once the parameters are entered and the user clicks on the
button.

and

2.The report Record source, or query feeding the report, should be linked to
the form with the parameters and using the forms controls for the query
criteria,

You could also check www.joshdev.com, they have a utility that creates
criteria for any given report, and you do not need to link the query to the
form, what it does is basically the 2 steps I described, only automatically,
you just need to create the query and the report, and the form in that
package does the rest
 
Back
Top