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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
yal said:
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
Click to expand...


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
 
Back
Top