Enable/Disable fields on a tabbed sub-form.
Posted on 2012-08-20
The below code is in place to indicate whether a report is required and then to select the type:
Private sub chk_Report_Required_Click
if me.chk_Report_Required = False then
me.og_Report_Type = Null
me.og_Report_Type.Enabled = False
me.og_Report_Type.Enabled = True
The og_Report_Type has three choices 1, 2, or 3
If Option 1 is selected in the og_Report_Type, I want to enable a date field on a tabbed sub-form (ISSIHSubmittedDate)
If Option 2 is selected in the og_Report_Type, I want to enable a differnt date field on a tabbed sub-form (FollowupReportDate)
If Option 3 is selected in the og_Report_Type, I want to enable a different date field on a tabbed sub-form (FinalReportDate)
If the chk_Report_Required is No, I want the three date fields disabled
Note: I know my naming conventions are screwed up but it would take a significant amount of work to re-do what's done.