when Command Button click need to display specific values at Combo box

[b.saimsc]

I have Created a form and in that forum 2 main command button click and each command have 2 sub command button clicks. Depend upon sub command button Click need to display the Specific Combo box dropdown.........I have written code like this



Private Sub Selection1_Click()


Combobox = "Z11110" and "Z222222" and "Z434343"


End Sub

Private Sub Selection2_Click()


Combobox = "Y11110" and "Y222222" and "Y434343"


End Sub

But i am getting Error



I have attached a demographics..please review and help me..........Thank you

[June7]

The error is because 'and' has no meaning as you have used it.

I don't understand what you are trying to do. Do you want to change the combobox RowSource dependent on some other criteria? How are the 2 main command buttons relevant to this?

The combobox RowSourceType property must be set to ValueList for code to change the RowSource property with a limited list:

Me.comboboxname.RowSource = "Z11110;Z222222;Z434343"

You have the combobox sized like a listbox. Above applies to listbox as well.

[b.saimsc]

Hi Super Moderator, Thank you very much for your reply....I need one more help depend upon row selection from Combo box or List box the text should be displayed at Text box. Please help me....Thank you

[June7]

What do you want displayed in textbox?

[b.saimsc]

Me.comboboxname.RowSource = "Z11110;Z222222;Z434343" given it's works fine.

Ex: Z11110 have some meaning like "Zee11110 is the first product of the year" So when i am click/selected Z11110 in Combo box / List box i have that description has to display at another newly created Text box.

Please help me! Thank you in advance...........

[June7]

How do you know it is the first product of the year?

Options:

1. expression in textbox ControlSource: =[comboboxname] & " is the first product of the year."

2. code in the combobox AfterUpdate event can populate textbox with whatever you want it to say
Me.textboxname = Me.combobox & " whatever you want to say."