Report to .pdf with field values in filename

[davem05]

Hi,
I have cobbled together some code to 1) open a report based on a query, 2) save the report,


The trouble I am having is using a text box value from the report as part of the filename.
Here is the code I am currently using

Function Macro2()


Dim myPath As String
Dim strReportName As String


    DoCmd.OpenReport "Results Certificate 2", acViewReport, "", "", acNormal


myPath = "C:\Users\Dave\desktop\"
strReportName = ![labNumber] & ".pdf"


    DoCmd.OutputTo acOutputReport, "Results Certificate 2", acFormatPDF, myPath & strReportName, False
    DoCmd.Close acReport, "Results Certificate 2"




End Function

it is the strReportName = labNumber which I am having problems with.
This is based on a text box called "labNumber", from a table called "Cat Details" if that is required.
Without that line the rest of works fine.

I have tried various ways of representing it from searches i have preformed over several hours, but nothing has solved it.

Any help at all would be hugely appreciated.
Thanks

[pbaldy]

Presuming it's on the report, try:


strReportName = Reports![Results Certificate 2]![labNumber] & ".pdf"

[June7]

Looks like what I do and it works.

Differences in my code:

1. open report in acViewPreview

2. omit the report name in the OutputTo so it just uses the open report

3. open report filtered with the WHERE argument of OpenReport

[davem05]

Thank you!
This worked, looking back through my previous attempts I had something very similar but it seems I had omitted the "s" from "Reports"
Once again, thank you!!

Presuming it's on the report, try:


strReportName = Reports![Results Certificate 2]![labNumber] & ".pdf"

[pbaldy]

Happy to help!

[June7]

The code is behind the report and report has the labNumber? Me alias should work although code should have worked without any qualifier prefix.

Me![labNumber] & ".pdf"

[pbaldy]

The code opens the report, so presumably is not behind it.

[June7]

Then if LabNumber is on the form, the Me alias should still work and so should have the code without prefix. So maybe the code is actually in a public module.

Macro2 is a poor name for a procedure. OutputPDF would be better.