run query with a form command button?

[Ashley]

is there any way to run an append query via a button on a form? i have a
field in a table (and on my form) that i want to be a running sum of a number
of other fields (also on the form).
i was going to try and make a macro to run the append query that calculates
the sum of the fields, but can't get them all to connect. (there is no macro
called "run append query")
thanks so much!
ashley

 

[pietlinden]

is there any way to run an append query via a button on a form? i have a
field in a table (and on my form) that i want to be a running sum of a number
of other fields (also on the form).
i was going to try and make a macro to run the append query that calculates
the sum of the fields, but can't get them all to connect. (there is no macro
called "run append query")
thanks so much!
ashley

A running sum of fields saved in a table? BAD design. Calculate at
runtime. what happens if you delete a record?

DoCmd.OpenQuery "QueryName"