changing "control source" or "row source" in subform

[bnath001]

HI,

In the detail section of my form, and I have a subform in that detail section. I have a combo box in the subform and I would like to change the control source/row source properties dynamically.

How can I access those properties of the combo box which is in the subform.

could someone give some suggestion?

thanks
bvyas

 

[JerryDennison]

You need only include the full path to the control:

Forms!MainFormName!SubFormName!ControlName

 

[bnath001]

Thanks Jerry. It works.

bvyas

 

[JerryDennison]

Imagine that. LOL

You're welcome.