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

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
 
R

Roger Carlson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of child form values shown in parent form and updated in database 3
Access Sub form opens before the main form in MS Access 0
Calculate total amount on continuous form line in sub-form 3
Sub-Form 1
How do I call a procedure in Main form from sub-form? 2
Form Subform Issue 2
referring to Subform Total in main form 1
Continous Form Running Sum 4

Top