Printing a single record

R

RW Brown

I am trying to print a single record form a command button
on the form. Everytime a try, I get all the records
printing out. How can I accomplish a single record
printout on a report? The form is called dimserv and the
report is called repairticket.

Thanks

Roger
 
D

Duane Hookom

Do you know which record you want to print? Assuming it is the one currently
displayed on the form and it has a numeric primary key field of ID.

Dim strWhere as String
strWhere = "ID= " & Me.ID
DoCmd.OpenReport "RepairTicket", acViewPreview, , strWhere

If your primary key field is text:
strWhere = "ID= """ & Me.ID & """"
_____________
Duane Hookom
MS Access MVP

DoCmd.OpenReport "RepairTicket", acViewPreview, , strWhere
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you print one record from a Report? 1
print each record twice on a page 2
Form filter then print report 2
Print button on form for single record 3
Print current record 11
Print command prints all reports in database? 15
Trying to print current record 1
Printing a single record from a form based on a report's layout 1

Top