Use the Form (or Subform's) Footer. Put a textbox in it with a controlI have a form build around a table which displays the jewelry we have in inventory and the value of each piece.
I have created a query (qryJewelryValue) that is a sum of the value field in the jewelry table.
What I would like to do is show that value on a label or in a textbox but I have not been able to do this. Ideally I would rather not use a subform. Is there a way to do this? And if there is, is there a way to do it without the query table opening up and overlapping the form when the form is run (I tried running the query on load and had this happen).
Any help would be appreciated.
The totals query isn't really needed, though if you want it for some
other reason, you can set the control source of a textbox to
In no case is it necessary to open the query datasheet at all - you
don't need to "run" the query in order for it to have a value!