Enable Combo when ticked.

[frankbutcher]

Hi.
I have sort of found an answer to my problem by this thread (Thread)
but it doesn't seem to be working.

I have (amongst others) a tickbox and a combo.

Basically, I would like it so if the tickbox is ticked, the combo is enabled, and no tickbox and it is disabled.

I have been putting this code:-

If Me.Helpdesk_Call = -1 Then
Me.Combo23.Enabled = False
Else
Me.Combo23.Enabled = True
End If

on the forms onCurrent event, and then changing the onUpdate event of the combo, but is doesn't seem to work. I have tried numerous amounts of variations, but nothing seems to be working.

Can someone help?

Thanks.

Frank.

 

[Crispy]

I haven't tested this but...

First set the Enabled property of your Combo to No.

Then place your code in the After Update event of the Check Box (note that the -1 value indicates that your checkbox is checked)

If (Me!Helpdesk_Call = -1) Then
Me!Combo23.Enabled = True
Else
Me!Combo23.Enabled = False
End If
End Sub

Hope this helps,
Chris

 

[Fear Naught]

You will also need that code in the On current event of the form.

 

[frankbutcher]

Thanks!!

Thats great, thankyou very much!!

Needed the code on the OnCurrent event as staated, otherwise when the form was closed and then opened, the combo wasn't enabled.

Thanks to both of you.

Frank.