Updating Sub Forms

[ajolson1964]

I have a form that has 2 sub forms within. I also am using a Combo box to select data then have that data updated to field located within the form that the combo box is located.. What I would like to do is have the combo box update (with the same data) a field in the sub form. Is that possible? Any help would be appreciated. I am using Office 07

 

[gwinn7]

Yes, controls in both directions are readily accessible.

To access controls on a subform look at this example...

Me.subformcontrol.form.mycontrolname

Gary
gwinn7

 

[gwinn7]

To assign a value...

Me.subformcontrol.form.mycontrolname = Me.combobox

Gary
gwinn7

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886