Solved

Filling a two column combo box with VBA code

Posted on 2008-10-06
2
375 Views
Last Modified: 2013-11-28
I have a table with two field in an MS Access 2003 database.  I would like to populate a two column combobox with the data from the table using VBA code.  How do I do that?
0
Comment
Question by:kshumway
2 Comments
 
LVL 84
ID: 22654956
Set the combos ColumnCount=2, and ColumnWidths=1;1

Set the RowSource as "SELECT YourFirstColumn, YourSecondColumn FROM YourTable"
0
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 22654999
Why VBA code?  
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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 …

910 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now