#Name?

[Guest]

I am using the following in a text box control source

=DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = " &
[Make ID])

However, #Name? appears in teh field. What is causing this please?

 

[Guest]

It can result because of few resons
The name of the table, or the fields mispaled.
Try and run the dlookup from the Inidiate window, with a value and see if
you get any error message.
=DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = PutAvalue
here")

Mybe the type of Make ID is string, in that case it should be written
=DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = '" & [Make
ID] & "'" )

Try and write the path of the form
=DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = " &
Forms![FormName]![Make ID])

MyBe the dlookup return null, so in that case
=nz(DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = " &
Forms![FormName]![Make ID]),0)

It a start HTH

 

[fredg]

I am using the following in a text box control source

=DLookUp("[ServiceIntMiles]", "[Service Intervals]", "[Make ID] = " &
[Make ID])

However, #Name? appears in teh field. What is causing this please?

1) Make sure the name of all the fields and the table in the
expression are spelled correctly.

2) Your syntax is OK if [Make ID] is a Number datatype.
If [Make ID] is text datatype then use:
"[Make ID] = '" & [Make ID] & "'"

3) The name of this control can not be the same as the name of any of
the fields in the expression.