Access Display two fields in ComboBox

Posted on 2012-08-22
Last Modified: 2012-08-24

I have a field in a bound form called "Template"
I have changed it to a ComboBox and want it to get data from a table called Templates which contains fields ID and Desciption
I want the user to see both the ID and description in the ComboBox and populate the bound table with the ID
How would I achieve this?
Question by:murbro
    LVL 61

    Expert Comment

    One way to do this is to create a combo box to select both fields, storing the ID and displaying the text (you probably already have this created on your form.  Then add an unbound textbox and set it's control source property to:

    = Forms!YourFormName!YourColumn(0)

    (include the = sign, and change the column number if needed to display the value of the correct column)
    LVL 61

    Accepted Solution

    Correction - I left out the combo reference:

    = Forms!YourFormName!YourComboName.Column(0)

    Open in new window

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Note that when the user drops down the combo, they can see all column values if you set the ColumnWidths appropriately, but when the user selects a value, only the Bound Column value will be shown (you can use the technique suggested by mbizup to show the other values).

    Author Closing Comment

    thanks very much

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    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 …

    729 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