Variable Not passing to query

[chris.williams]

I have a command button which when clicked, runs a VBA macro which saves a report to a PDF for the current record. The report is based on a predefined filter for based on the current ID field on the original form.



I have tried setting the criteria field to the current record of the form, setting a variable to the ID field. But the query is not getting the information to compare and the output of the report is all #Type and #Error.

When the macro is run, the query runs and prompts for the information the criteria is looking for.

How do I pass a variable from a form to a query in VBA?

Public Sub SaveFormToPDF_Click()

Dim CurrentID

CurrentID = [TaskSR]
MsgBox (CurrentID)

DoCmd.OutputTo acOutputReport, "rpt_Certificate", acFormatPDF, "..\Desktop\" & [FTSOCertNumber] & ".pdf"

End Sub

[hertfordkc]

Missing values for variables are usually the result of flawed syntax. Depending on your version of Access, the variable references range from me.something to Forms.[Formname].[variablename] and sometimes the periods are replaced by exclamation points.
So...experiment with your variable references.

[chris.williams]

I am using Access 2010 - all syntax has been posted along with the errors. I also inserted a mesbox to see what was in the variable and to see if the form side was working and it displays correctly - but that is from within the form, not the query.

I am thinking the issue must reside within the query side. I have also posted an image of the syntax in the query.

Any other or more specific ideas?