|
 |
access thread: Sub-form running total
Message #1 by "Henry Napier" <hdh.napier@c...> on Sun, 12 Aug 2001 13:34:45
|
|
I HAVE A FORM WITH SUB-FORM, BOTH CONTAINING NUMERICAL FIGURES.
I NEED TO PLACE ANOTHER TEXT BOX ON THE MAIN FORM WHICH WOULD
SHOW THE RUNNING TOTAL OF ONE OF THE FIELDS IN THE SUB FORM.
CAN ANYONE HELP.
Message #2 by "Richard Lobel" <richard@a...> on Sun, 12 Aug 2001 15:40:17 -0700
|
|
Put a text box on the sub form setting it to the running total. Make its
Visible property False. Then put a text box on the main form and in the
OnChange Event of the sub-form's text box set the main form's text box
to equal the sub=form's text box.
Hope this helps.
Richard Lobel
Accessible Data
richard@a... <mailto:richard@a...>
Cell: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Mon, 13 Aug 2001 12:26:59 -0700
|
|
Put an unbound text box on the main form, and set its control source to an
appropriate call to DSum(), e.g.,
=DSum("FieldToSum", "TableWhereFieldToSumLives", "FK = " & me.txtPK)
Then in the AfterInsert event of the subform, call the .Requery method of
the running sum text box.
Hope that helps.
-Roy
-----Original Message-----
From: Henry Napier [mailto:hdh.napier@c...]
Sent: Sunday, August 12, 2001 6:35 AM
To: Access
Subject: [access] Sub-form running total
I HAVE A FORM WITH SUB-FORM, BOTH CONTAINING NUMERICAL FIGURES.
I NEED TO PLACE ANOTHER TEXT BOX ON THE MAIN FORM WHICH WOULD
SHOW THE RUNNING TOTAL OF ONE OF THE FIELDS IN THE SUB FORM.
CAN ANYONE HELP.
|
|
|
View Cart
