Displaying Subform Totals

[abbyanu]

Hi folks

I have two linked tables (1 to many relationship or parent and child), and using a form and a subform to input data into both tables. The tables are: purchase invoices (main form) and purchases (subform), with several purchase records linked to one invoice number.

I wish to display the subtotal of the subform, i.e. the total of the purchases within an invoice, in a textbox on the data entry form for verification purposes. How can I do this? Please help.

 

[JoeMiller]

Your textbox could use the DSum function to go and look at the table with the data (purchases) and add up the values. The only issue is you'll have to issue a requery command on that text box whenever you change data in the subform so the data gets updated when changes are made.

HTH Joe Miller
joe.miller@flotech.net

 

[abbyanu]

I'm new to Access programming... I tried the DSUM function and I ain't see nothing... please help.

 

[JoeMiller]

Do you have an email address that I can email a DB to? I have a very small sample of how to do exactly what you're looking for..

Joe Miller
joe.miller@flotech.net