By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,332 Members | 1,103 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,332 IT Pros & Developers. It's quick & easy.

Enable/Disable a subforms object

P: 52
I have a form (Custom_Code) that has a sub form (Support_Groups_Form) associated to it. I have a need to enable and disable the fields depending on user selection but I am having trouble controlling the sub form objects. I am using the
Expand|Select|Wrap|Line Numbers
  1. Me.Project_Manager.Enabled = True
  2.  
Code to control the main forms objects but again I have no clue as to how to control the sub forms objects.

If the sub forms name is “Support_Groups_Form” and the object within this form is named “ITS_ NT_Applications” how do I format the command to enable and or disable the object?

Any help would be greatly appreciated.
Birky
May 31 '07 #1
Share this Question
Share on Google+
1 Reply

puppydogbuddy
Expert 100+
P: 1,923
I have a form (Custom_Code) that has a sub form (Support_Groups_Form) associated to it. I have a need to enable and disable the fields depending on user selection but I am having trouble controlling the sub form objects. I am using the
Expand|Select|Wrap|Line Numbers
  1. Me.Project_Manager.Enabled = True
  2.  
Code to control the main forms objects but again I have no clue as to how to control the sub forms objects.

If the sub forms name is “Support_Groups_Form” and the object within this form is named “ITS_ NT_Applications” how do I format the command to enable and or disable the object?

Any help would be greatly appreciated.
Birky
Assumption: Code to disable/enable is being executed from the main form.

Disabling the subform control will also disable all the controls within the subform control object. If you want to disable only certain controls within the object, your syntax should be like this:

Me!YourSubformControl.Form.[controlToBeDisabled].Enabled = False
Me![Support_Groups_Form].Form.[a control].Enabled = False
May 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.