Combo box doesn't update

[MrsNic]

I have a form that is being used as a survey.

I have a set the properties of one of the combo boxes to .enabled = false.

I want the If an option button is selected the corresponding combobox should be enabled. It works the first time the form is opened but will not update if a different option button is selected.

I have tried requery and update but these don't seem to work.


Code used

If Question4a.value = 1 then
question4b.enabled = true
question4c.enabled=false
end if

If Question4a.value = 2 then
question4b.enabled = false
question4c.enabled= true
end if


I know I am doing something really silly, but I can't see it.

 

[PHV]

Code used
Where ?
In the Current event procedure of the form and the AfterUpdate event procedure of Question4a too ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MrsNic]

I have placed the code in the AfterUpdate, OnChange properties for Question4a and in the Current for the form but it is still not working.

I have set the original properties of the comboboxes 4b and 4c to .enabled = false

Thanks for your help.

Cath