a2k (9.0.6926) SP-3 Jet 4.0 SP-7
strDogTagID in table containes 1234567-A, the first 7 characters in
each record are unique
strDogTagID in the form containes 1234567
In After Update Event in form, how can I lookup information in the dog
record using the first 7 characters of strDogTagID?
The following dosen't work
dtmRTDate = Nz(DLookup("[dtmRTDate]", "[tbl_DLicense]", _
"[Left(strDogTagID, 7)] = """ &
[strDogTagID] & """"), Null)
How about SQL replacement syntax?
Thanks, John