How do I reflect a a sum of values in the sub form in the main form

  • Thread starter Thread starter VK
  • Start date Start date
V

VK

I have two tables
T Main with columns
CNum
Customer
SubTotal
Tax
Grand Total

T Detail with columns
CNum
Product
Qty
Price
Amount

There are two forms F Main for table T Main and a sub
form F Detail for table T Detail. Both show the above
columns on the form and are linked on CNum. The amount is
calculated on the F Detail and updated in the T Detail. I
kept this column in T Detail thinking it would ease the
issue given below.

I need to show the Sub Total on form F main and update
the Sub Total box in the table T Main. Sub Total is the
sum of all the Amount for which D Num's match.

If there is a Tax value it is added to Sub Total to give
Grand Total.

The issue - I need to update the Sub Total on the form F
Main and table T Main.

Thank you in advance for your help and time.

Thank you,
VK
 
On my website is a small sample database called "SubformReference" which
illustrates how to do this as well as a number of other things dealing with
forms and subforms.
 
Back
Top