D
DowningDevelopments
Hello everyone,
I seem to have backed myself into a corner here, ive got a form called
ReceiptForm which asks the user what a customer can be charged for from a
drop down list. The selection opens a popup form that the user can fill in
and save and each form is based on a table for that type of payment, eg
deposits popup form is based on the deposits table etc, there are 5 different
payments.
To find out the total of what is owed for that receipt, i have devised a
Union query to list the different amounts that are paid in called
PaymentList, this is shown in a listbox on the main ReceiptForm so the user
can view the different forms that have been filled in. What i need to do is
get the total and put it into a text box in the footer of the main
ReceiptForm called [totalcharges].
I have a query called PaymentlistSum which works as follows:
SELECT DISTINCTROW Sum([PaymentList].[Amount]) AS [Sum Of Amount]
FROM PaymentList;
but how do i put this total into a text box??? Also when do i do it, ideally
id like to update the value everytime i submit a new payment. The listbox is
updated everytime a popup form is closed and works well, i cant use the
afterupdate on the listbox as its updated programatically but that would be
ideal!
With much thanks
form a stumped Amit
I seem to have backed myself into a corner here, ive got a form called
ReceiptForm which asks the user what a customer can be charged for from a
drop down list. The selection opens a popup form that the user can fill in
and save and each form is based on a table for that type of payment, eg
deposits popup form is based on the deposits table etc, there are 5 different
payments.
To find out the total of what is owed for that receipt, i have devised a
Union query to list the different amounts that are paid in called
PaymentList, this is shown in a listbox on the main ReceiptForm so the user
can view the different forms that have been filled in. What i need to do is
get the total and put it into a text box in the footer of the main
ReceiptForm called [totalcharges].
I have a query called PaymentlistSum which works as follows:
SELECT DISTINCTROW Sum([PaymentList].[Amount]) AS [Sum Of Amount]
FROM PaymentList;
but how do i put this total into a text box??? Also when do i do it, ideally
id like to update the value everytime i submit a new payment. The listbox is
updated everytime a popup form is closed and works well, i cant use the
afterupdate on the listbox as its updated programatically but that would be
ideal!
With much thanks
form a stumped Amit