How to define rowsourcetype for a value list in vba?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AccessBeetle
    New Member
    • Jul 2009
    • 111

    How to define rowsourcetype for a value list in vba?

    The seoncd line in following code is always red as it contains some error.
    Code:
     Me.Combo31.RowSourceType = "Value list"
            Me.Combo31.RowSource = "spvr";"mngr";"user"
    Please help
  • ajalwaysus
    Recognized Expert Contributor
    • Jul 2009
    • 266

    #2
    Code:
    Me.Combo31.RowSourceType = "Value list"
    Me.Combo31.RowSource = "spvr;mngr;user"
    or
    Code:
    Me.Combo31.RowSourceType = "Value list"
    Me.Combo31.RowSource = "'spvr';'mngr';'user'"
    This second one is untested, but the first one should work.

    Let me know if this works,
    -AJ

    Comment

    • AccessBeetle
      New Member
      • Jul 2009
      • 111

      #3
      Both of them works. I tested.
      Thanks much!! It really helped.

      Comment

      Working...