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.
Subscribe to our Windows Secrets Newsletter - It's Free!
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.