Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-09-10
3
Medium Priority
?
456 Views
Last Modified: 2014-09-10
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
Comment
Question by:Fordraiders
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40314738
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
 
LVL 3

Author Comment

by:Fordraiders
ID: 40314790
brain lapse..
Thanks
0
 
LVL 3

Author Closing Comment

by:Fordraiders
ID: 40314792
thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question