limit what the reports show.

[DonLduk]

Hello all.

I have created a Report which is exactly as I want to display by clicking a button on a subform.

But, the report shows all the results from the query (of course...) . For example, the Query alone shows information for Adam, Betty and Charlie, hence the report will show the organized data for Adam Betty and Charlie.

If I put the Query in a subform so it shows only data for the selected field (for example, in the main form I select Adam, then in the Query results as subfrom I only see the information for Adam), and then add a button in the subfrom to display the Report, the report still shows the information for Adam, Betty and Charlie.

Can anybody help me limit the Report to what the Query is showing as a subfrom, and not the complete results of the Query? I really couldn't find information about this or how to modify reports.

thank you very much in advance.

 

[Rich]

Use the Where Clause of the OpenReport method, there are examples in the Help file

 

[DonLduk]

Thanks! After you pointed me to the "Where" clausule of the OpenReport, I searched the forums and found this help guide:

http://www.baldyweb.com/wherecondition.htm

now it works! Really thanks!