Combo box visable based on another combo box

[TheViruz30]

I have 2 combo boxes one called primary which has Primary, Secondary, Tertiary

I also i have combo box called "Is There another insurance" which has yes, no, none,

What i want to do is if user selects primary the combo box called is there another insurance becomes visiable however if user selects Secondary, or Tertiary from the primary combo box the combo box called Is There another insurance becomes invisable.

Any Ideas,

Thanks,

 

[John Big Booty]

You will need to put a logical test, in the on Current event for the form and on the after update event of the combo box. That will test the value of the first combo box.

You might also want to set the visible status to both your other combo boxes to false as a default.

If comb1.value = 1 then
[INDENT]combo2.visible = true
combo3.visible = false[/INDENT]
else
[INDENT]combo2.visible = False
combo3.visible = true[/INDENT]
End if