Sum query (single value) to appear in a text box - how?

P

paul.schrum

I am have a SUM query (which works okay). I want to display the value
of that query in a read-only text box on a form. However, when I set
Control Source for that text box to

=[qry_theSumQuery].[summedField]

it does not work for me. I do not see any other way to do this. Can
someone give me some advise on how to do this?

Thanks.

- Paul Schrum
 
D

Damon Heron

one way is in the form's load event, put:

Me.yourTextbox = nz(DLookup("summedfield", "qry_theSumQuery"),0)

Damon
 
Top