Directions how to activate controls on a subform (e.g. requery)

[yal]

How do I activate controls on a subform (e.g. requery)? I checked the help
options and they were not there. I would think this is a basic concept for
help options

 

[Marshall Barton]

How do I activate controls on a subform (e.g. requery)? I checked the help
options and they were not there. I would think this is a basic concept for
help options

What do you mean by "activate controls"?

If you mean that you want to enable a control on a subform
by using code in the main form, then it would be like this:

Me.subformcontrolname.Form.controlname.Enabled = True

Or, to requery a combo/list box:

Me.subformcontrolname.Form.controlname.Requery

Or, if you want to requery the subform's data source:

Me.subformcontrolname.Form.Requery