Combox Boxes and displaying Values

Posted on 2012-09-07
Medium Priority
Last Modified: 2012-09-11
So on a form (Record Source is is tblReviewers)I have a combo box that pulls data from a Table called tblSpecialities.  The user selects the approrpiate speciality and continues to fill out the rest of the form, which is then stored in tblreviewers.   So I understand that the value for the speciality is stored in the record in tblreviewers, however I want to display the actual textual value as opposed to the numeric value associated with the speciality chosen on a different form.  how do i do that?
Question by:seamus9909
  • 3
  • 2
LVL 77

Expert Comment

ID: 38376112
Put the same combo box on the second form

Author Comment

ID: 38376161
the second form is a display only form, so what I want to show them is the actual value not the Id.

Example     Speciality = Medical Doctor      =    ID = 15.
LVL 77

Expert Comment

ID: 38376173
Set the width of the ID column to 0.  (I had assumed you had done that on your original combo - is there any reason for the user to see the ID at all?)
Independent Software Vendors: 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!


Author Comment

ID: 38376283
no the ID means nothing to the User.
LVL 77

Expert Comment

ID: 38376303
So set the first column width value to 0.  You will then see the next column when you select a value from the dropdown list.
LVL 20

Accepted Solution

clarkscott earned 2000 total points
ID: 38376431
Let's say your recordsource for your dropdown is "qry" and includes (in this order)... ID, Text.
This is 2 columns.
In the properties of the combobox

Column count: 2
Column Widths: 0";2"
Bound Column: 1

This keeps the bound value to the ID... but makes the ID column invisible to your combo box... thus displaying the text.

Scott C

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

750 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