Combo Box Question

[SoxPats83]

I have a form with 20 Combo Boxes in it organized vertically. my goal here is to have only 1 combo box appear on load and not have the second one appear until there is a value selected in the first one. and so on for the third, and fourth, and fifth, etc. these combo boxes are placed within a tagged page in the form and eventually i would like to have a command button in this tabbed page to move the selected to other text boxes in the same form, but that is a different question entirely. if anyone could help me with this whole visible/not visible problem, i would appreciate it. thanks.

 

[ChrisLayfield]

You need to chage the Visible format on the property sheet to No. This will cause the selected item to not show on the load.

Then add an AfterUpdate code to make the next combobox visible.

 

[Never Hide]

Go to the "On Load" event of the form and put the following code in there

Me.combobox_1.Visible = True
Me.combobox_2.Visible = False
Me.combobox_3.Visible = False
Me.combobox_4.Visible = False

and so on fo the rest of the combo boxes.
Then go to the "After Update" event of "combobox_1" and in there,after the code you are going to use you put this part of code

Me.combobox_2.Visible = True

And then you repeat the same process for all of your combo boxes

 

[mMoran]

This is so nice. Thanks for letting me know.
I love you! Yaaay! Happy New Year!
____________

mp4 to mp3 converter
[FONT=&quot][/FONT]

 

[Never Hide]

You are welcome
Happy New Year to you too