Yes. [AUTAC_LOOKUP_CODE] is a text field as are the rest of the fields in
the code.

Klatuu wrote:
That error is misleading. It usually means one of the names in the DLookup
doesn't match the names in the table. The issue is that Access sends the
request to Jet and waits for a reply. Jet can't find the name, so can't
complete the request, so it tells Access it has canceled the request. Access
then raises that error.
Be sure the spelling of all the names both table and field are correct. The
only other thing is to ensure your syntax is correct for the data type of the
field in the criteria argument. As written, it is expecting
[AUTAC_LOOKUP_CODE] to be a text data type.
Does anyone know what is wrong with the following code:

[quoted text clipped - 40 lines]

Shannan