SetValue Subform Records

F

F1stman

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top