DLookup #Name? error

[bthomas]

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.

[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!

 

[alansidman]

Is the Dlookup located on the main form or on the subform you are referring to?

Alan

 

[bthomas]

Hi alansidman,

Thanks for responding.

It is in the subform. I haven't even tested it in the main form yet.

 

[xenou]

"[ExceptionCode] = "& Forms![Administrative-AccountRolodex_ExceptionCodesSubform]![ExceptionCode])

I don't see a space between the second quote and ampersand above. That's a problem, probably.

If the DLookup Function is in the subform itself I think you can just use (because its the same container object):
"[ExceptionCode] = " & [ExceptionCode]

If ExceptionCode is not numeric (if it is text) you need quotes:
"[ExceptionCode] = '" & [ExceptionCode] & "'"

All just guesses on my part. Maybe it's something else! Trial and error should get you there. If you have now actually put this "subform" in a main form then that might change things...

(Note that many databases require a letter or an underscore as the first character of a table name. You may want to avoid tables starting with numbers to make your project more scalable).

 

[bthomas]

Thank you! I will try this. Also, thanks for the tip. I did not know that about the table names.