Problems with Conditional Formatting on Combo box.

[festerian]

Hi everybody - I'm a new access user and would appreciate some help.
I'm trying to create a form, on which I'm trying to disable/enable a combo box, based on the value entered in another combo box above it on the form.

Basically what I tried was to select the combobox in Design view - click on Format > conditional format.
Then I changed 'condition' to 'expression is'
then entered -> Category = Misc
and finally clicked on the enabled box hoping to grey it out.

The idea is that I have two combo boxes on the form, with values typed in (not from other tables). Selecting 'Misc' in the first box should disable the second one.

Any ideas? I'm desperate!!

[JConsulting]

Hi everybody - I'm a new access user and would appreciate some help.
I'm trying to create a form, on which I'm trying to disable/enable a combo box, based on the value entered in another combo box above it on the form.

Basically what I tried was to select the combobox in Design view - click on Format > conditional format.
Then I changed 'condition' to 'expression is'
then entered -> Category = Misc
and finally clicked on the enabled box hoping to grey it out.

The idea is that I have two combo boxes on the form, with values typed in (not from other tables). Selecting 'Misc' in the first box should disable the second one.

Any ideas? I'm desperate!!

form_current event

if me.combo1.column(x) = "Misc" then
me.combo2.enabled = false
else
me.combo2.enabled = true
end if
 

[JConsulting]

form_current event

if me.combo1.column(x) = "Misc" then
me.combo2.enabled = false
else
me.combo2.enabled = true
end if
 

sorry, submitted too quick.

Put that code on your form's on_current event. Replace Column(x) with the field index in your Combo1 where 'misc' is found. for example, if your combo's rowsource is returning two fields, the far left is 0, next is 1, etc...

Hope this helps.
J

[festerian]

Oh my my my... that works wonderfully!

Thank you SO SO SO much!!

I really appreciate it.

[JConsulting]

Oh my my my... that works wonderfully!

Thank you SO SO SO much!!

I really appreciate it.

anytime!
J