printing 2 copies of current record

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello. I'm what you may call a novice in Access, but I was
wondering if anyone could help me.

I need to print two copies of a report of the record
currenly displayed on screen only.

How do I do this?

Thanks for any help you can give me.
 
Hello. I'm what you may call a novice in Access, but I was
wondering if anyone could help me.

I need to print two copies of a report of the record
currenly displayed on screen only.

How do I do this?

Thanks for any help you can give me.
Click to expand...

The record should have a Unique Prime Key field.
If so, and the field is a Number datatype, then:

DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " &
Me![RecordID]
DoCmd.SelectObject acReport, "ReportName", False
DoCmd.PrintOut acPrintAll, , , , 2


Change [RecordID] to whatever the actual name is of the Prime Key
field.

If [RecordID] is a ext datatype, then use:
"[RecordID] = '" & Me![RecordID] & "'"
 
Back
Top