Combo Box Visible Yes/No

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

"Gus" wrote in message
news
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...

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/

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks for the rapid response but it did not work. If you have any other
ideas please let me know.

Thanks
Gus

"Dirk Goldgar" wrote:

"Gus" wrote in message
news
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...

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/

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Gus" wrote in message

Thanks for the rapid response but it did not work. If you have any
other ideas please let me know.

"Dirk Goldgar" wrote:

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.

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)