What code action updates a sum query

dbaldwin

Registered User.
Local time
Yesterday, 22:49
Joined
Feb 13, 2011
Messages
40
I have a form based on a query that sums the values in a field. When I was writing the code to store the sumed value into a memory variable, I didn't know if simply writing something like memvar = frm!control would cause the underlying query to update and provide the most up to date sum. I chose to open the form DoCmd.OpenForm "frm" before I stored the value to the memory variable. It worked fine but, for future reference, was I just wasting my time with an unnecessary step?
 

Users who are viewing this thread

Back
Top Bottom