I'm lost.
I am trying to create a form that automatically fills a field from a lookup table based on the criteria in another field.
The criteria field is called ExceptionCode and the autofill field is called PRASE. The lookup table is named 04LookupExceptionCode. The form name is Administrative-AccountRolodex_ExceptionCodesSubform.
My code is.
When I toggle to form view the autofill field returns #Name?. What am I doing wrong.
Thanks in advance!
I am trying to create a form that automatically fills a field from a lookup table based on the criteria in another field.
The criteria field is called ExceptionCode and the autofill field is called PRASE. The lookup table is named 04LookupExceptionCode. The form name is Administrative-AccountRolodex_ExceptionCodesSubform.
My code is.
Code:
[FONT=Times New Roman]DLookup("[PRASE]", "04LookupExceptionCode", "[ExceptionCode] = "& Forms![Administrative-AccountRolodex_ExceptionCodesSubform]![ExceptionCode])<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT]
When I toggle to form view the autofill field returns #Name?. What am I doing wrong.
Thanks in advance!