How to print a single Record's report?

[yes sir]

I have a feeling this question may have surfaced on this forum before.



What I am in the process of doing is having a button feature on a form. Once clicked, it will print the corresponding report for whatever record you were viewing in Form View.

I have taken a stab at some VBA code (I googled around, and copied some code) and I get a message like so:

"Run-time error '2497':
The action or method require a Report Name argument."

Anyone know what this could be?

Here is the code:
Private Sub Print_Report_Click()
Dim Master_Report As String
Dim strCriteria As String

strCriteria = "ID = " & Me.ID
rptName = "Master_Report"
DoCmd.OpenReport Master_Report, acViewPreview, , strCriteria

End Sub

--------
Where Master_Report is the name of the report, and ID refers to the ID of the record I am currently viewing in Form View.

[ajetrumpet]

the reason you're getting the error is because Access is trying to locate the string that is supposed to be supplied in the first argument of the docmd.openreport command and there isn't one. Since you have already assigned the variable "rptName" a string, replace that Master_Report argument that's current there with rptName and you'll be just fine.

Access might also ask you to enclose the rest of the command after "OpenReport" in () because your first argument is a variable. That is common for Access to do.

[Access_Blaster]

Try this http://allenbrowne.com/casu-15.html

[yes sir]

Ok, I ditched that code.

I'm slowly getting more comfortable with the Macro Builder. I was able to use that to get it to work.

RunCommand ---> Save Record
OpenReport ---> Report Name: Used my report's name here, View: Print Preview, Where Condition: [ID]=[Forms]![use your Form's Name][ID]

[Access_Blaster]

Glad it worked out for you.

[RuralGuy]

So I guess you are ready to follow the link in my sig and mark this thread as Solved then, right?

[yes sir]

So I guess you are ready to follow the link in my sig and mark this thread as Solved then, right?

I have a history of marking all of my threads solved. No link necessary.

[RuralGuy]

Thanks you.