Payments totaled

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,
I have a table where I record membership payments made by members of
a club.On the main data input form I wanted to display the cumulative total
collected to date.I enquired about this before and an unbound control was
suggested.I now have a button on the form header which executes a query
which in turn totalises the payments. The only problem is that the result is
displayed in a standard query result form, which does not look so good. Can
I have the result displayed in a textbox next to the button in the header
instead, or some other kind of display box, and if so how.Tia John
 
You really don't need a command button/query/form setup just to show one
calculation. As was probably suggested before, create an unbound control on
your form, set its control source to something like:
=DSum("[payments]", "myTable")

In the After Update event of your payment form (or, more likely, subform)
put some like:
Forms!myForm!myPaymentTotal.Requery

This will update the calculation and display the current total paid after
each payment record is entered or changed.
-Ed
 
Back
Top