Adding things...

[KirstenII]

I'm back again...thanks for all the help so far. You guys have been far more useful than all the books I've been trying to learn from.

I have a mainform with two subforms on tabs...one-to-many relationship with both subforms. What I'd like to do is be able to have a box on the mainform that contains a total for values entered on the subforms. However, I can't figure out how to link this box with the subform controls and how to keep it updated as new records are entered in the subform. Any suggestions?

 

[pdx_man]

use the builder button (that's the wand with the elipses [...] [diff than wizard]) under the control source for an unbound control on the main form. That will help you map to a control on a subform.

 

[KirstenII]

Sorry, I'm not following....

 

[pdx_man]

I sent you a file with print screens. It is actually the elipses (...) (the three dots are called elipses) that show up in the properties when you click on the control source for a text box. That is what you want to use to build the path.

[This message has been edited by pdx_man (edited 01-25-2001).]

 

[BarkerD]

Use the following format to reference a bound forms' control.

Forms![SubFormName]![ControlName].Property

Duane Barker