Problems Using a Saved Query as a Control Source

[TWD]

Hey guys,



This is my first attempt at refering a query for a control source on a text box.

I created a simple select query that has a sum function field to give me a grand total. I want to display this total on my report.

I added a text box and selected my query as the control source. It saved with no errors. However, when I run the report, no data is displayed. When I return to the design, the control source is blank again.

What am I missing here? The text box does say unbound which I'm not sure what that means. Pretty green here. lol Can anyone help?

[pbaldy]

You can't have a query as the control source. It can be a field from the form's record source, or a calculated value. From the sound of it, your simplest solution is a control source of:

=DLookup("FieldName", "QueryName")

or you could dump the query and use a DSum().