Control Source Expression builder giving "#Name?" error 1

[cctonto]

I'm trying to get a text box in a report to read a query result. I use the expression builder for the Control Source to find the query and then the field within the query. It looks like this:

= [DCASH_After_Layaway_Inventory]![SumOfTotal]

This seems all correct but then I get "#Name?" error for the field.

I need to display several fields on the report, all fields comming from different queries.

Access 2002

-Thanks-

 

[GingerR]

sounds like the query is not part of the report?
try dlookup - it will get data from tables and queries that are not part of the report's recordsource.

=dlookup("SumOfTotal","DCASH_AfterLayaway_Inventory")

this will pull that value.
If you only want to pull that value for a certain record, you'll have to put the criteria in as well:

dlookup("SumOfTotal","DCASH_AfterLayaway_Inventory","ID = " & [ReportID])

where the "ID" in the query is equal to the "ReportID" (or whatever you call it) in the Report.

Hope this helps--g

 

[cctonto]

Thanks GingerR. Works great