How to build a combo box value list ?

[gazolba]

I need to dynamically build a value list for a combo box.

Cannot find anything in access help

How do I look at the object model to find methods and properties ??? - no help in access help

 

[TonyJollans]

Hi gazolba,

You need to

(a) set the RowSourceType property to [blue]"Value List"[/blue], and ..

(b) set the RowSource property to a list of semi-colon separated values to fill the list in left-to-right, top-to-bottom order, for example 1;"one";2;"two"

Note that if the list contains quotes they will need to be doubled up, for example ..

[blue][i]Combo[/i].RowSource = "1;""one"";2;""two"""[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.