• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

reference combo box on form problem specific column from a function call

Access 2010 vba.

Simply trying to reference a combo box on a form to get a value.  from a function call

' s2 = "BR2GCK"
      s2 = Forms!Form1![Combo5].Column(1)


ME keyword will not work in this case.
cant seem to get the syntax right

Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
is this giving you a problem

  s2 = Forms!Form1![Combo5].Column(1)

did you set the Column Count of the combo to at least 2

.Column(1)  refers to the 2nd column of the row source of the combo box.
0
 
FordraidersAuthor Commented:
brain lapse..
Thanks
0
 
FordraidersAuthor Commented:
thanks
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now