Printing the current record from a form to a report

M

Marc

I have a form and a report that are almost identical. I want to create a
button on the form to allow me to print the report. So say I'm on recordID 15
when I print the report, the report should just have recordID 15's
information. How would I go about setting the criteria for the button?

Thanks
 
M

Marshall Barton

Marc said:
I have a form and a report that are almost identical. I want to create a
button on the form to allow me to print the report. So say I'm on recordID 15
when I print the report, the report should just have recordID 15's
information. How would I go about setting the criteria for the button?
Click to expand...


Use the OpenReport method's WhereCondition argument to
specify the filter criteria. E.g.

DoCmd.OpenReport . . ., WhereCondition:= "RecordID=" &
Me.RecordID
 
M

Marc

Okay in the macro I created in the where condition field I put "RecordID=" &
[Me].[RecordID]

I attatched the macro to the button in the form, tried to run it, and a pop
up box appears. How come it didn't print the record I was on in my form?
 
M

Marc

I got my button to open the report for the current record. Now how do I get
it to print automatically? When I hit my button I want the report of the
current record to be able to print automatically.
 
M

Marshall Barton

Marc said:
I got my button to open the report for the current record. Now how do I get
it to print automatically? When I hit my button I want the report of the
current record to be able to print automatically.
Click to expand...


I don't understand the issue. Opening the report either
prints the report directly to a printer or displays it in a
preview window (depending on the view argument). If the
report is open in preview window, users can click on the
Print toolbar button to send it to the printer. I often
provide two form buttons, one for previeing and one for
printing.
 
M

Marc

I wanted the report to print automatically. I didn't want my users to have to
open the report then hit print. I want the user to be able to hit the button
and it automatically sends the report of the current record to the printer.
 
M

Marshall Barton

Then set the OpenReport method's View argument to
acViewNormal

If the report is currently opening is preview, then the View
argument you have now is acViewPreview.
 
Top