Combo Box Visible Yes/No

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two Combo Boxes in a form in Access2003 and want the second Combo Box
to be Visible or not depending on the item selected on Combo Box 1.
Something like;
IFF combo1="a", Combo box2.visible=true, False

I hope this explain what I need. I thank you for your consideration and
help...

Thanks
Gus
(e-mail address removed)
 
Gus said:
I have two Combo Boxes in a form in Access2003 and want the second
Combo Box to be Visible or not depending on the item selected on
Combo Box 1. Something like;
IFF combo1="a", Combo box2.visible=true, False

I hope this explain what I need. I thank you for your consideration
and help...
Click to expand...

Basic code would be along the lines of

Me!ComboBox2.Visible = (Me!ComboBox1 = "a")

You need to execute this line in the AfterUdate event of ComboBox1 and,
if ComboBox1 is a bound control, in the Current event of the form/
 
Thanks for the rapid response but it did not work. If you have any other
ideas please let me know.

Thanks
Gus
 
Gus said:
Thanks for the rapid response but it did not work. If you have any
other ideas please let me know.
Click to expand...

It should work, so if it didn't, either you applied it wrong or there's
something about your situation that I don't know yet. In what way did
it "not work"? Did you get an error message, or did nothing happen at
all? Please post (by copy/paste) the exact code you tried, and give
some more background details of the form, the controls, and the way you
tested. Be aware that it's possible for a combo box to show one value
but actually store another -- maybe that's the trouble.
 
Back
Top