Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB help to print a single record in a report
- Thread starter Tfrank
- Start date
use the docmd.openreport command to open the report and pass the report some criteria which will define your current record
Example:
Dim Criteria as string
Criteria = "[Primkeyfield] = " & me![formfield]
docmd.openreport "Report Name",acpreview,,Criteria
My syntax may not be exactly correct. Use access help to get the full syntax for the openreport command. Also you will need to add single or double quotes if your primary key is a text field.
Maq B-)
<insert witty signature here>
Example:
Dim Criteria as string
Criteria = "[Primkeyfield] = " & me![formfield]
docmd.openreport "Report Name",acpreview,,Criteria
My syntax may not be exactly correct. Use access help to get the full syntax for the openreport command. Also you will need to add single or double quotes if your primary key is a text field.
Maq B-)
<insert witty signature here>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
