Referencing on blank form #Name? error

[10kz]

If I have a blank form, and I want to reference a query in a text field, e.g.

query name: qry_TotalValue
field: TotalValue (numeric)


I want that field to be displayed in my blank form. I've tried by click on the control source and selecting the field from the query.

=[qry_TotalValue]![TotalValue]

This produces a "#Name?" value instead of the numeric value.

 

[liddlem]

Have you set the format on the field in designer view.
I often find that even though the field is set to numeric, I still have to set the format to something. IE General Number or Fixed or Scientific etc.

 

[10kz]

Yep, I've tried general number, fixed, currency etc. Still giving me the #Name?

 

[Galaxiom]

Try

=Dlookup("[TotalValue]","[qry_TotalValue]")

 

[10kz]

Try

=Dlookup("[TotalValue]","[qry_TotalValue]")

Perfect that worked

 

[missinglinq]

FYI, the use of DLookup() is the easiest way, using VBA, to reference a Field that is not part of the RecordSource for the Form; not just in this situation. More simply put, you cannot directly reference a Field by following its Domain Name (domain being a Table or Query) wit the Field Name, i.e.

[QueryName]![FieldName]

or

[TableName]![FieldName].

Referencing, like this, is done when using a SQL Statement is appropriate.

Linq ;0)>