Control Combo Box selection

[Cillies]

Hi all,

I have three combo boxes on a form! what I want to be able to do is
manipulate access to the last two combos, depending on the selection
of the options in the first combo.

I have several options in each combo. In the first combo I want the
user to be fit to select any of the options to allow the user to
access the other two combo's, unless the user selects the option "Not
Interested".

Currently I tried disabling combo2. Then in my afterupdate event of
the 1st combo I entered:

Me.Combo2.Enabled = (Me.Combo1 = "Interested")

Which works fine, but I am unable to select any of the other options
to allow access to the other two combos. I tried tweeking the code but
to no avail.

Hope someone can Help, I know this may be easily sorted, but its only
easy if you know the method.

Kindests regards to anyone that can help.

[Wayne Morgan]

What do you mean by "but I am unable to select any of the other options to
allow access to the other two combos"? Does the first combo box lock-up and
not let you make any more selections?

--
Wayne Morgan
Microsoft Access MVP
"Cillies" <le*@prologic.ie> wrote in message
news:ba**************************@posting.google.c om...

Hi all,

I have three combo boxes on a form! what I want to be able to do is
manipulate access to the last two combos, depending on the selection
of the options in the first combo.

I have several options in each combo. In the first combo I want the
user to be fit to select any of the options to allow the user to
access the other two combo's, unless the user selects the option "Not
Interested".

Currently I tried disabling combo2. Then in my afterupdate event of
the 1st combo I entered:

Me.Combo2.Enabled = (Me.Combo1 = "Interested")

Which works fine, but I am unable to select any of the other options
to allow access to the other two combos. I tried tweeking the code but
to no avail.

Hope someone can Help, I know this may be easily sorted, but its only
easy if you know the method.

Kindests regards to anyone that can help.

[devdex.com]

Yea! thats right.
Sorry for the confusion.

If I selected say! "Interested" (which is what i have used in my code)
combo2 allows me to select the from its list (which by the way is a
Value List)
and if I select any other option in combo1, combo2 becomes disabled.

You see I want to be able to select any of the option which will allow
me to access combo 2&3 unless the Option "Not Interested" is selected
then I want comb2&3 to become disabled.

I am not sure how to incoroprate combo3 into the code either.

Hope this is clearer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lumpierbritches]

You will probably need to do an if then else statement for the other selections
I would think. Or, I'm sure there is a reference to the cbo Control, but I'm
too new and blue to know it, yet.

Michael

[Wayne Morgan]

Ok, you want combos 2 and 3 to be enabled unless you select "Not Interested"
in combo 1. If "Not Interested" is selected, combos 2 and 3 should be
disabled. Is this correct? If so, in the After Update event of combo 1

Me.Combo2.Enabled = Not (Me.Combo1 = "Not Interested")
Me.Combo3.Enabled = Not (Me.Combo1 = "Not Interested")

The Not keyword will reverse the value of the True/False. So, if Combo1 is
Not Interested then the value will be True, the Not will reverse this and
assign False to the left side of the =.

--
Wayne Morgan
MS Access MVP
"devdex.com" <an*******@devdex.com> wrote in message
news:40*********************@news.frii.net...

Yea! thats right.
Sorry for the confusion.

If I selected say! "Interested" (which is what i have used in my code)
combo2 allows me to select the from its list (which by the way is a
Value List)
and if I select any other option in combo1, combo2 becomes disabled.

You see I want to be able to select any of the option which will allow
me to access combo 2&3 unless the Option "Not Interested" is selected
then I want comb2&3 to become disabled.

I am not sure how to incoroprate combo3 into the code either.

Hope this is clearer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[devdex.com]

Thanks Wayne, it works a treat.

I was so close but yet so far.

Everything I pick up is minimises' the knowledge that I don't have.
Cheers
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!