D
David
syntax error (missing operator) in query expression 'CUSTID=2R CONST'.
I am getting the above error when I try to run my code below.
invoicesepmat = DLookup("[SeparateInvoicePerMat]", "custmnt", "[CUSTID]=" &
customer)
I get a run time error 2001 You canceled the previous operation with this
code.
invoicesepmat = DLookup("[SeparateInvoicePerMat]", "custmnt",
"CUSTID=customer")
customer is a variable that was obtained in the previous code. Any ideas on
why my lookup keeps throwing these errors?
Thanks,
Dave
I am getting the above error when I try to run my code below.
invoicesepmat = DLookup("[SeparateInvoicePerMat]", "custmnt", "[CUSTID]=" &
customer)
I get a run time error 2001 You canceled the previous operation with this
code.
invoicesepmat = DLookup("[SeparateInvoicePerMat]", "custmnt",
"CUSTID=customer")
customer is a variable that was obtained in the previous code. Any ideas on
why my lookup keeps throwing these errors?
Thanks,
Dave