Combo, listbox

Posted on 1998-07-20
Last Modified: 2010-05-03
This may be an easy question.  With the combo box, list box, ect.  I am using it to connect to an access query.  I selected a specific field and recordsource for it.  I only has the first record visible in the drop down box.  How do I change it so It has all records?


connect to access.
Have 20 names in names table
choose lastname as recordsource
only has 1 name in drop down box, should be 20.

Question by:DAVIDH
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

Expert Comment

ID: 1466254
Using the DBCombo and DBlist controls.

Author Comment

ID: 1466255
I am using the controls thats not the problem, the controls ONLY show the first record in the drop down box.  I want all the records.

Author Comment

ID: 1466256
I am using the controls thats not the problem, the controls ONLY show the first record in the drop down box.  I want all the records.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 1466257
Assume you are using a datacontrol

You need to specify the Rowsource (the datacontrol for the table,  and then set the listField to the column you want to show.

If you need help on doing that, let me know

Author Comment

ID: 1466258

I have done all of that.  In my message I said what the problem is.   It connects to the database, connects to the query, connects to the recordsource, but when I click the down arrow on the drop box, it only shows the first record, all the others are blank.  I want it to be filled with all the records.  

When I click the arrow control on DATA1  it will move to the next one, and so on, but I want the user to be able to choose from a drop down box, similar to the way they would in access.


Accepted Solution

Dalin earned 50 total points
ID: 1466259

What I show is additional to what you have done.

What you have done it to bind the combo to the recordset, which automatically shows the value of the field you connect to, but only one at a time.

To show the whole list from a field of the table, you need to have a dbCOmbo and set the rowsource and list field.

The other way is to put all the records (the 20 some) in the List property of the regular combo, but you need to do that everytime a new value added to the field.

Let me know If I did not make myself clear.


LVL 18

Expert Comment

ID: 1466260 = 2 '(Dropdown List)

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

695 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