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

Print Report From Data On Form

P: 14
I would like a report called Open Work By Employee to print from the data that is on the form. The field that will pull the information is the ID field. Can you give me some insite on this.

Thanks
Dec 19 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I would like a report called Open Work By Employee to print from the data that is on the form. The field that will pull the information is the ID field. Can you give me some insite on this.

Thanks
Try placing this code behind a button on your form: Replace object names I used for illustrative purposes with the actual names used in your application. Assumption made: EmployeeID is a numeric data type.
Expand|Select|Wrap|Line Numbers
  1. Private Sub YourButton_Click()
  2.  
  3. DoCmd.OpenReport "Open Work By Employee", acViewPreview, , "[EmployeeID] = " & Me!EmployeeID
  4.  
  5. End Sub
Dec 20 '07 #2

Post your reply

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