I am working in a form that has three subforms that I want to only be shown if the appropriate value is selected in a combobox. The cbo is a lookup field tied to a table. Right now there are only three records "Correspondnece," Scheduling Request," and "Memorandum." When a user selects an item from the dropdown, I'd like it to show the corresponding form.
I tried this, with no luck.
Private Sub DocTypeID_AfterUpdate()
If DocTypeID.Value = "Correspondence" Then
[Forms]![frmExecSecRecordEntry]![frmCorSub].Visible = True
I was going to continue with the three options. Any ideas?