How to extract the RunningSum textbox and have it work on another form.

  • Thread starter Thread starter orsonros
  • Start date Start date
O

orsonros

Hi Need help badly!

When 2 Forms are opened, how to extract data from either ones text
boxes, what if one is having a calculated text box like a runningsum
that changes per record. How could I use that data on the other form
and still have the data change recordwise while doing the runningsum.

By it self the runningsum works on its repected Form. The moment the
form is placed as a subform it does not do the runnning total.

Help
orson
 
like a runningsum that changes per record
I never seen this phrasing. To me a running sum is the sum of multiple
records. If you are talking about a sum based on data in a single record
then just do it in the query that is the record source.

Reference a textbox this way --
[Forms]![FirstForm]![Textbox]

But the second form will need to be refreshed each time the first form is
changed.
 
Back
Top