View Full Version : Report only current record


Mabuya
11-24-2006, 01:52 AM
Hello,

I got a little question,

I made some reports but the records that i have in the tables/querys.

How can i get a report preview of only the record i have open in the form, so that if i print it will only print the 1 report.

lightray
11-24-2006, 02:01 AM
You need a button on the form. In the onclick event, use the DoCmd OpenReport for the report, add to the statement the Primary Key of the record. The primary key should also be on your report, set visible = No
Is that of some help?