Aug 7 2006, 11:46 AM
I have a form with 7 subforms in it... for each one, I have 12 values that I need to add up within each subform. What is the code for that? Thanks
Aug 7 2006, 12:42 PM
There's several ways to do this . . . I sometimes use a listbox . . . but I make it look like a textbox to the user, run a totals qry on the qry for your subform and display a total to the user.
You can refresh the total when you change tabs using the OnChange event or use some other trigger if the data is changed.