I am attempting to perform a Dlookup to populate an unbound control with the following command:
Me.txtad_Ship.Value = DLookup("[ad_Ship]", "[Tanks]", "[Job_ID] = " & Me.Job_ID)
For some of the records, I get an error message of "Syntax error (missing operator) in query experssion '[Job_ID]...