Combo Box

[Clifford Thomas]

How do I insert values or data in to the drop down list of the combo box. I
would like to know the step by step procedure.

 

[Sam Wilson]

if you have a combobox (call it say cmb_1) in a form then the following will
add "A new item" to its options:

cmb_1.additem "A New Item"

And if you wanted to add "Item 1" to "item 10"

dim i as integer
for i = 1 to 10
cmb_1.additem "Item " & i
next i

If you put this code into the form.initialize script it'll be there when you
open the form.

Sam

 

[JLGWhiz]

This site provides another method.

http://support.microsoft.com/kb/161598

You can also use the RowSource property to populate a ListBox or ComboBox.
Most of these methods are described with sample code in the VBA help files.