Full Version: Subform total
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
bennerakrug
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
fredrisg
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.

Steve
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.