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?

 

[nithubp]

use

visible = trure/false properties



set other 2 fileds visible= false on form load

and set condition for the first filed to make the other two visible

 

[smig]

Call this sub from these events:
FromLoad
TypeSecurity_AfterUpdate
Location_AfterUpdate

Private Sub EnableProjectType()
 
If Me.TypeSecurity = SpecifcValue1 and Me.Location = SpecifcValue2 then
  Me.ProjectType.Enabled = True
Else
  Me.ProjectType.Enabled = False
End IF
 
End Sub

 

[vbaInet]

Call this sub from these events:
FromLoad

slight typo there, Form Load, i.e. the Load event of the Form.

 

[xwnoob]

Thx it worked

 

[smig]

Glad we could help