Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    19

    Unanswered: 3 Column field seperation

    i have a field in a form which is a lookup combo box. it has a column count of 3. is there a way using vba code to seperate the value from the combo box into 3 seperate values?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    With FirstColumn, SecondColumn, ThirdColumn being three variables and ComboLookUp the name of the combo:
    Code:
    FirstColumn = Me.ComboLookUp.Column(0)
    SecondColumn = Me.ComboLookUp.Column(1)
    ThirdColumn = Me.ComboLookUp.Column(2)
    Have a nice day!

  3. #3
    Join Date
    Jul 2011
    Posts
    19
    Thankyou sinndho simple when you know how isnt it, dont know why i didnt think of that, cheers mate, helpful as always

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •