combo box, make .visible when combo field selected

carlchapman

Registered User.
Local time
Today, 17:08
Joined
Jul 25, 2006
Messages
29
Nice and easy one for all those pro's out their. I have a form which has a hidden combo box. I want this combo box to only be displayed when 1 of 2 values in an other combo box are selected.

So far i have made default for combo box to .visible = false, and in combo box one selected after update. If !me.??????????? (not sure of what syntax to use)
combobox2.visible = true

end if

combo box one records are selected from a table. the two fields i need picked up are "AgentA" & "AgentB" in VBA do i use || for the or statement?
 
IF (Me.Combox = "AgentA" OR Me.Combox = "AgentB") THEN
combobox2.visible = true
ELSE
combobox2.visible = false
END IF
 
thankyou :)
 

Users who are viewing this thread

Back
Top Bottom