DLookup-retrieves only 1st record in query

[Guest]

I'm trying to pull records from a query, into a form. The first record in
the query appears for every record in the form.

My expression is . . .

=DLookUp("[Customs Value and Duty Totals]![SumOfValue]","Customs Value and
Duty Totals","[Customs Entries]![Entry Number]=[Customs Value and Duty
Totals]![Entry Number]")

This expression is working for records I pull from tables, but not from this
query.

Any thoughts?

 

[Guest]

In the control source of a text box in the form where you want the output of
the query to be displayed, try and write something like

=DLookUp("[SumOfValue]","[Insert here the Query Name]","[Entry Number field
name in query]= "& [Entry Number field name in form])

If the is string try
=DLookUp("[SumOfValue]","[Insert here the Query Name]","[Entry Number field
name in query]= '" & [Entry Number field name in form] & "'")

 

[Guest]

Nope . . . not working. I either get an error or totally blank.
--
Thanks,
Theresa

In the control source of a text box in the form where you want the output of
the query to be displayed, try and write something like

=DLookUp("[SumOfValue]","[Insert here the Query Name]","[Entry Number field
name in query]= "& [Entry Number field name in form])

If the is string try
=DLookUp("[SumOfValue]","[Insert here the Query Name]","[Entry Number field
name in query]= '" & [Entry Number field name in form] & "'")

--
\\// Live Long and Prosper \\//
BS"D

I'm trying to pull records from a query, into a form. The first record in
the query appears for every record in the form.

My expression is . . .

=DLookUp("[Customs Value and Duty Totals]![SumOfValue]","Customs Value and
Duty Totals","[Customs Entries]![Entry Number]=[Customs Value and Duty
Totals]![Entry Number]")

This expression is working for records I pull from tables, but not from this
query.

Any thoughts?

 

[Douglas J. Steele]

It's probably because of the spaces in the second parameter. If you're going
to insist on using spaces, you need to enclose the name in square brackets:

=DLookUp("[Customs Value and Duty Totals]![SumOfValue]","[Customs Value and
Duty Totals]","[Customs Entries]![Entry Number]=[Customs Value and Duty
Totals]![Entry Number]")