Set value of combobox through vba!

[Miroslav]

I have form containing 8 comboboxes. On click on command button i want to set the item/caption/selection of combobox. How should I do that? Button has OnClick event built in VBA. What would be the code?

 

[GinaWhipp]

Something like...

Me.YourComboBox.RowSource = "Your SELECT Statement goes here"
Me.YourLabel.Caption = "Your Caption goes here"

I don't know what the Item is so can't help out there. The above goes in the Command Buttons On_Click event with the other stuff.

 

[Miroslav]

Thanks. It worked!

 

[GinaWhipp]

You're welcome!