Enable combo box only if user selects a certain value in 2 other combo box

[xwnoob]

Hi,



So my form has three combo boxes named TypeSecurity,Location,ProjectType. I want to disable projectype in the form unless the user selects two specific values in the other combo boxes which are "Property" in TypeSecurity and "Local" in Location. Only if they select these options then the combo box will appear. How do i do this?

[ssanfu]

One method:

For combo box "TypeSecurity", use

Private Sub TypeSecurity_AfterUpdate()
   If Me.TypeSecurity = "Property" And Me.Location = "Local" Then
      Me.ProjectType.Enabled = True
   Else
      Me.ProjectType.Enabled = False
   End If
End Sub

For combo box "Location", use

Private Sub Location_AfterUpdate()
   If Me.TypeSecurity = "Property" And Me.Location = "Local" Then
      Me.ProjectType.Enabled = True
   Else
      Me.ProjectType.Enabled = False
   End If
End Sub

[xwnoob]

One method:

For combo box "TypeSecurity", use

Private Sub TypeSecurity_AfterUpdate()
If Me.TypeSecurity = "Property" And Me.Location = "Local" Then
Me.ProjectType.Enabled = True
Else
Me.ProjectType.Enabled = False
End If
End Sub

For combo box "Location", use

Private Sub Location_AfterUpdate()
If Me.TypeSecurity = "Property" And Me.Location = "Local" Then
Me.ProjectType.Enabled = True
Else
Me.ProjectType.Enabled = False
End If
End Sub

Thx it worked