Disabling Combo Boxes

[petercummins]

Hi people i once again need your help!

What I would like is for a combo box to disable if a certain vaule is entered into another combo box.

I have a combo box [FrontDoorType] and when the vaule is N/A or blank then the [FrontDoorColour] combo box is disabled.

Have tried using the conditional formatting tool but keep getting lost.

Is there a way to do this?

Thanks for all your help!

 

[namliam]

Use the after update event of the first combobox
then do secondcombo.enabled = false if your condition is true...

 

[petercummins]

Thats great thanks. My solution is:

If FrontDoorType = "N/A" Then
FrontDoorColour.Enabled = False
FrontDoorColour = "N/A"
Else: FrontDoorColour.Enabled = True
End If

This changes my second combo box to disabled and has the value N/A. The value is changed to N/A so that it shows up in a report I have attached to it.

 

[namliam]

Just a general tip, dont use "Else:"

Just put your else bit on the seperate line, improves general readability of your coding....