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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Reference Subform's Control 0
Subform reference 20
subform control reference fails 6
Subform/Form Referencing 5
lock/unlock controls 0
Multiple subforms 0
Referring to control on subform 2
Subform of a subform 1

Back
Top