Combo Box

[phillpc]

I have a combo box with 3 selctions. If user selects the option "Denied" I want to open a field from my table UR and have the user select a reason for the denial that will be stored in the table. I'm a novice user and I can't find any way to do this. Is this possible?

 

[nick]

Put another combo box on the form which has the denial reasons in it but make the visible property false.

The put code such as below onto the Afterupdate event of your first combo box.

if firstcombox = "Denied"
denialreasons.visible = true
else
denialreasons.visible = false
endif

where firstcombobox and denialreasons are the name sof the combos on your form