Printing a single record

  • Thread starter Thread starter RW Brown
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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
Trying to print current record 1
Print every other record in a form 13
Printing a single record from a form based on a report's layout 1
Printing report with single record data from a form 3
Print button on form for single record 3
Form filter then print report 2

Back
Top