2011-01-21, 07:48 #1
- Join Date
- Jun 2003
- Camp Lejeune, North Carolina, USA
- Thanked 0 Times in 0 Posts
Access 2007 Printing single record using report
We have a database I am building that lists all jobs we have received for clients to view. They can query by Job Title or Location. I want to put a button on report so that a single job can be printed. On print properties window print current record is greyed out.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2011-01-21, 15:13 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 12 Times in 12 Posts
docmd.OpenReport "rptJobs",view:=acViewNormal,wherecondition:="JobI D=" & txtJobID
I made a bunch of assumptions: rptJobs is your report, JobID is the job identifier, and txtJobID is a control on your form containing the job you want to look for.