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?

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.

Sorry, I'm not following....

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).]

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

Forms![SubFormName]![ControlName].Property

Duane Barker