combo box mystery

[99mel]

Does anyone know whether you can actually add, delete...(things like that) in a Combo box using vba????????????<br>
<br>
I think Access has just made it so you just use tables for puttin data into combo boxs or list boxs<br>
<br>
<br>
Anyone came across this problem!!!

 

[elizabeth]

Not sure I understand the question. You can set a value (new change or reset to null or zero length) just by saying something like cboAnyName= &quot;Tom&quot;. If cboAnyName is bound to a table that will accomplish the add delete or change of that field when you exit that record.

 

[99mel]

What i was looking to do is to populate the combo box with actual values that you can select. I want to be able to put more than one string into the combo box using vb. Then being able to select these strings from the combo box.<br>
<br>
Thanks

 

[elizabeth]

See Access help topic (F1) under the combobox (data) properties for RowSourceType property and RowSource property. You can fill it with a reference to a table, a query/SQL statement, or a list of values etc.