I have a form named "frmquoteProject" which has a combo named "ProjectType" which pulls the list from a table.. If u select Wood for example I want to show a subform named "subfrm6ftprivacy" if you select anything else I want to hide the subform...
Here is the code I put in afterupdate on the combo "ProjectType" and I know I cant use the ("me.visible = true") statement cause that would hide my main form.. What would I change this code to and hide the subform "subfrm6ftprivacy" upon selection and not the main form??
Here is the code but not sure how to make it not me.visible and subform not visible instead..
Code:
Private Sub projecttype_AfterUpdate()
If [ProjectType] = "Wood" Then
subfrm6ftprivacy.Visible = True
Else
End If
End Sub
SOLUTION..................
Code:
Private Sub projecttype_AfterUpdate()
If [ProjectType] = "Wood" Then
Me.Controls("subfrm6ftprivacy").Visible = True
Else
Me.Controls("subfrm6ftprivacy").Visible = False
End If
End Sub