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??

Ususally people ask the opposite question http://www.access-programmers.co.uk/ubb/smile.gif The answer is the same however, look at the code that opens the report and remove the filter parameter.

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

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.