Need help disabling a combobox on subform or disable subform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sirdevo
    New Member
    • Nov 2009
    • 9

    Need help disabling a combobox on subform or disable subform

    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.cboSoilSe ries.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,
    Devo
  • sirdevo
    New Member
    • Nov 2009
    • 9

    #2
    I just found out how to disable the subform. I used this code in main form.
    Me.Report_Soil_ Series_Subform1 .Enabled = False

    Devo

    Comment

    Working...