VBA references to subform

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

What is the proper syntax to reference a subform in VBA. I have a form named
"Subscribers" with a subform called "Subscriptions". I would like to change
the "Enabled" properties on a field in the subform named "Amount_Paid" How
do I do this.

Thanks,
Jay
 
If your code is in the main form, use:
Me!Subscriptions!Amount_Paid.Enabled = True

Note: Subscriptions is the name of the subform control which may or may not be
the same as the subform!

If your code is in the subform, use:
Me!Amount_Paid.Enabled = True
 
Back
Top