Tick Box

[fabby1]

Hi

I have a series of tick boxes, which when ticked display a drop down box for the user to select.

Is there a way, that when the user de-ticks the tick box the combo box dissappears.

I seem only at the moment to tick and then tick again to make it dissappear.

Thanks

Phil

 

[peachmelba]

Phil

I would do something like this

Me.Combo0.Visible = Not (Me.Check2.Value)

Regs

Peachmelba

 

[fabby1]

Peach

That works great, but in reverse.

When I tick the blank box and piut a tick in it, nothing happens.

When I untick it the combobox appears

any ideas

Thanks

Phil

 

[peachmelba]

Phil

The NOT() statement reverse what the value is.

Simply remove that and it should work how you want.

Regs

Peachmelba

 

[fabby1]

BINGO !!

Thanks Peach

Phil