Syntax Error

[GLEberts]

I am getting the following error when I click on a command button.

Runtime error 3075
Syntax error (missing operator) in query expression "[jobinvoiceid]'=.


I have a main form "fmjob" with a subform "fmjobinvoice"
both are linked together by "jobId" and "jobinvoiceid"

I have a command button with on the click handler:
Private Sub Command1158_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rptjobinvoice", acViewPreview, , "[jobinvoiceid]=" & JobinvoiceID

End Sub

what I am trying to do is open up a report to view a specific record.

I have this in a few places in my DB on my main forms only not on the subforms and it works fine.

I have worked this a ton of different ways and can't seem to come up with the fix.

thanks for any suggestions.
Gary

[missinglinq]

This syntax

"[jobinvoiceid]=" & JobinvoiceID

is only correct if the jobinvoiceid field is defined in your table as a Number. Is it?

IF it's defined as Text then

"[jobinvoiceID] = '" & JobinvoiceID & "'"

would be correct.

Where is Command1158 located and where is JobinvoiceID located, form-wise?

Linq ;0)>

[GLEberts]

JobInvoiceID is defined in my table as a "AutoNumber"


Command Button 1158 is placed on the subform "fmjobinvoice" not the main form "fmjob"

"JobInoviceID is placed in the subform "fmjobinvoice" not the main form "fmjob"

[ChipR]

What is the exact text in the error message you are getting?
"[jobinvoiceid]'=.
Either the error message or your code has not been transferred correctly.

[OldBirdman]

Could JobinvoiceID be Null? That would fit the error message. How about Debug.Print JobinvoiceID?