Syntax Error

[desk4tbc]

Hi, I don't know why its giving me a 3075 runtime error.
"Syntax error(missing operator) in query expression 'Patient_ID='."

Private Sub Form_Current()
If IsNull(DMax("Group", "PetList", "Patient_ID=" & Me.Patient_ID)) And Not IsNull([Patient ID]) Then
    Me.Parent!imgExc.Visible = True
    Me.Parent!labExc.Visible = True
Else
    Me.Parent!imgExc.Visible = False
    Me.Parent!labExc.Visible = False
End If
End Sub

Its saying I'm missing an operator but isn't the "=" the operator in this case? Patient_ID is an integer, could that be the reason?

[pbaldy]

The lack of a value after the = in the error implies that it isn't finding a value in Me.Patient_ID. I'd double check that's the right control.

[desk4tbc]

Ah Thanks. The problem was aggravated by the fact that the first line was Null in Patient_ID, so I received the prompt at load. Now I know what to look for if that happens again.

[pbaldy]

No problemo.