SetValue Subform Records

[Guest]

Hello,
I am trying to run a setvalue macro with the press of a button on a parent
for which will cause toggle the values of a field in the subform between
positive and negative numbers. When I simply run a set value on that field,
it toggles the first record but no others.

Is there a way to run the macro so that ALL subform records are changed?

FYI: This form toggles between debits and credits under a specific invoice
where seperate accounts are used to pay it.

Many thanks in advance!

Adam Kemp

 

[Guest]

You will need to run an update query using main form Master/Child link
information as criteria.