Solved

Fill a 2 column combo box from an ado recordset

Posted on 2012-03-30
2
321 Views
Last Modified: 2012-04-13
I have an ADO recordset with 2 columns,

I want to populate this into a combo box.

I've tried using the .AddItems in a loop through the recordset but this only works with 1 column.

I'm using Access 2010.  Any ideas?
0
Comment
Question by:lee_jd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37787856
Can you post the code you were trying...? and post any errors you were getting...?
...and post the relevant properties of the combobox...

I am sure you were just missing something like setting the column count to 2, or having set the column width of a column to 0
...or missed something like this in the code
rst!Col1=...
rst!Col2=...

JeffCoachman
0
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 500 total points
ID: 37788451
You might be able to just use the SQL for the recordset as the combo box's row source.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

688 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