View Full Version : Calculated results on Form from Sub Form


George Mardall
06-04-2001, 09:56 AM
I wonder if you can help me with the following:

I am preparing an order entry form in MS Access.

The main form contains 12 tabbed subforms.

When data has been entered into the subforms using drop down lists, a calculated ‘SUM’ is produced within the subform.

How can I create a running total on the main form as the ‘SUM’ on each subform is completed?

Some subforms will have a zero ‘SUM’.

With Thanks