Generating a Report From a Form

[p00le]

I am trying to populate a report and a form with results from the same query. Currently, the user enters the criteria of a parameter query and a form opens displaying the results of the query, one record at a time. I have a command button on the form which opens the report. However, the report reflects only the record displayed on the screen at the time the command button was clicked. I need for the report to populate with all the results of the query. Any suggestions??

 

[Pat Hartman]

Ususally people ask the opposite question

The answer is the same however, look at the code that opens the report and remove the filter parameter.

 

[p00le]

I have looked high and low but I cannot find a filter of any sort attached to the report. Any other suggestions??

 

[Pat Hartman]

Look at the code that opens the report. You can search for "OpenReport" in the form's module. The last parameter is probably the filter.