Form field displayes results of Query

[Guest]

I would like to appologise to start with, I think I'm having a really bad day.
I have a query that displays the required answer. I want to press a command
button on my form and have a field display the result from my query?

Not normalised!!!

Query2
Result is in field "SumOfOPENQTY"

Command button is on form "Wave Release Screen" and called "Command157".
The field it should display the results of the query in is "Total Units"

Help, please

Thanks
Dean

 

[Bob Quintal]

I would like to appologise to start with, I think I'm having a
really bad day. I have a query that displays the required
answer. I want to press a command button on my form and have
a field display the result from my query?

Not normalised!!!

Query2
Result is in field "SumOfOPENQTY"

Command button is on form "Wave Release Screen" and called
"Command157". The field it should display the results of the
query in is "Total Units"

Help, please

Thanks
Dean

"How shall I run thee, Let me count the ways."

if the query returns 1 row with 1 column, a DLookup would be the
simplest way.
in the button's OnClick Event, this is all you need.
Me.[Total Units] = Dlookup("SumOfOpenQty","Query2")

opening a recordset in code and returning the value would be
another way.

If the query returns several rows, with a classifier and the
sum, you could add a subform control, use the query as the
SourceObject and simply issue a me.subformname.requery in the
button's OnClick event