Dlookup in table won't work

[EMS]

Looking for an explanation of why a dlookup function in a form is not
working. Here are the details:

Form name = "Main Form"
"Office Number" field is bound to the record source for the form
"Territory" field contains the dlookup function

Table name = "Offices"
Table fields used in dlookup are "Office No" and "Territory Name"

I need the "Territory" field in the form to lookup the "Office Number" field
in the "Offices" table and return the value for "Territory Name"

Here's is the dlookup function:

=DLookUp("[Territory Name]","[Offices]","[Office No]=" & [Forms]![Main
Form]![Office Number])

The error I get is #Error.

Any help is appreciated.

 

[EMS]

Issue resolved - no need to reply

 

[Mike Painter]

Looking for an explanation of why a dlookup function in a form is not
working. Here are the details:

Form name = "Main Form"
"Office Number" field is bound to the record source for the form
"Territory" field contains the dlookup function

Table name = "Offices"
Table fields used in dlookup are "Office No" and "Territory Name"

I need the "Territory" field in the form to lookup the "Office
Number" field in the "Offices" table and return the value for
"Territory Name"

Here's is the dlookup function:

=DLookUp("[Territory Name]","[Offices]","[Office No]=" & [Forms]![Main
Form]![Office Number])

The error I get is #Error.

Any help is appreciated.

Relate the tables and use a query, there does not appear to be any need for
a look up.