Form to Report Filter

[melissaku]

I have created a purchase order form for use in my office. What I need is to
create a command button that will open and print a report of just the current
record. I can get the command button to open a print preview of the report,
but it brings up the entire report (ALL purchase orders in the database).
Can anyone tell me how to build a filter, macro, or code to only bring up the
current record within the report? THanks for your help!

 

[Allen Browne]

Use the primary key value of the record in the form, in the WhereCondition
of OpenReport.

Details and example in:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html