VBA references to subform

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
 
P

PC Datasheet

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
 

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

Top