Printing a report by parameter query?

[beamers]

I am a self taught newbie to VBA. What I would like to do is when I click on the print button from a form a dialog box ask for the record number (which is my primary key). I enter the number and it pulls up that report record and prints just that page. I have been working on this for months and have searched the internet for hours and have all the VBA books you can name.

[Rabbit]

Please show us the code.

I assume you're using the DoCmd.OpenRepor t method to open the report in print preview mode. The OpenReport method has a filter parameter that you can use to filter the report.