By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Printing a report by parameter query?

P: 1
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.
Jan 9 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,365
Please show us the code.

I assume you're using the DoCmd.OpenReport method to open the report in print preview mode. The OpenReport method has a filter parameter that you can use to filter the report.
Jan 9 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.