R
Rich
I currently am using a button on a subform to calculate
and send an invoice. The subform can and does in some
cases contain several records pertaining to a # in the
master form it is attached to. I want to, using the same
button, have it so calculations will be made on every
record in the subform instead of just the one the button
is on, when it is pressed. For example.
Master Form # 123
Has:
Subform record A with certain values
Subform record B with certain values
Subform record C with certain values.
Currently, I have to hit the button on A, B and C to get
the values calculated and these are then put into 3
different invoice e-mails. I want to hit 1 button, on
either A, B or C and have the proper values calculated on
every record and then put into a single invoice e-mail.
The invoice is a report, and the returned values are
in "Detail" so I know they will be listed. I just don't
know how to get all the values calculated using the
subroutine, and then outputted to one collective report.
Thank you in advance for any help...
and send an invoice. The subform can and does in some
cases contain several records pertaining to a # in the
master form it is attached to. I want to, using the same
button, have it so calculations will be made on every
record in the subform instead of just the one the button
is on, when it is pressed. For example.
Master Form # 123
Has:
Subform record A with certain values
Subform record B with certain values
Subform record C with certain values.
Currently, I have to hit the button on A, B and C to get
the values calculated and these are then put into 3
different invoice e-mails. I want to hit 1 button, on
either A, B or C and have the proper values calculated on
every record and then put into a single invoice e-mail.
The invoice is a report, and the returned values are
in "Detail" so I know they will be listed. I just don't
know how to get all the values calculated using the
subroutine, and then outputted to one collective report.
Thank you in advance for any help...