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

Need help disabling a combobox on subform or disable subform

P: 9
There is one combobox on a subform named Report Soil Series Subform1. The combobox is named cboSoilSeries. I need to disable this so the user can't enter values. I could also disable the whole subform since this is the only control on the subform. I've tried this line of code but it says you can't disable the control while it has focus.
Forms![Survey Report]![Report Soil Series Subform1].Form.cboSoilSeries.Enabled = False

The combobox does not have focus when I run that line of code. I'm using Access 2007.

Thank you for the help,
Nov 24 '09 #1
Share this Question
Share on Google+
1 Reply

P: 9
I just found out how to disable the subform. I used this code in main form.
Me.Report_Soil_Series_Subform1.Enabled = False

Nov 24 '09 #2

Post your reply

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