I'm getting the following error message when trying to open the application:
Runtime error 3075 syntax error (missing operator) in query expression "[ID]='
it applies to the following text:
Me.txtHeader = IIf(IsNull(DLookup("[Address1]", "Customers", "[ID]=" & [CustomerID])), "", DLookup("[Address1]", "Customers", "[ID]=" & [CustomerID]))
'DoCmd.ApplyFilter , "JobID = " & Me.JobID
End If
I just cant see it? Any ideas anyone?
Thanx
Kym :