Filling out a combo-box

[GeorgeJ]

Elsewhere in this forum I am asking for help in updating the info in a subform after its underlying data table gets changed. While I am waiting to see if I will be able to accomplish what I am trying to accomplish using a subform. I am exploring the possibility of using a drop-down combo box instead. I have not been successful in finding references on how to change combobox info using VB.

Would anybody out there be able to help me with this situation?:

Suppose I have a Simple form MyForm which has 3 controls, Button1, Button2 and ComboBox1.



When Myform loads there is nothing in Combobox1. The user press Button1 and the Combobox gets 3 string items - "CB1", "CB2" and "CB3" which display immediately.

The user then presses Button2 and ComboBox1 reverts to its original state of having nothing in it.


Would anyone out there be kind enough to show me what the code should look like in the Click routines of Button1 and Button2, or to show me a link to somewhere where VB programing of combobox contents is discussed in detail?

Thanks in advance

[pbaldy]

You would set the RowSource property, either to a query or table if the values were stored there, or a value list if you used that. To empty, set it to an empty string ("").