Field in form shows #name?

[JesVic]

I created a summation query to count total number of checkmarks in a database and in the same query I asked to summarize the numbers in a field of the database.

This is the result of the query: 2 single columns with 760 for the total pages, and 4 for the total number of books.




I go to a form and insert a textbox. I insert an expression function: =[Query_statistiek]![Totaal_blz] to insert the above value "760" in the textbox. When I switch again to the form normal view, the field is filled with #name? instead of the retrieved value who is saved in the query (760).

Any idea what I did wrong? I checked several times the properties but do not know what I have forgotten. I'm a visual impaired person.

[xps35]

Try:
=DLookUp("Query_statistiek";"Totaal_blz")

[JesVic]

Try:
=DLookUp("Query_statistiek";"Totaal_blz")

Yeah! Just switch item 1 and item 2 like here: =DLookUp("Totaal_blz";"Query_statistiek")
Great, many thanks!