Solved

Fixing id numbers showing in combo box not the desciption

Posted on 2014-02-10
2
368 Views
Last Modified: 2014-02-19
I just got this fixed on my database, then I changed something on the combo and its not working.  Now it is showing the ID numbers on a different combo box.  

See the attached database on the Contact Form.  There are three combo boxes at the top.  It is the top right third box that is showing the id numbers rather than the description.  

How do I fix it?  I assume it is in the sql code.  What do I need to change with it.
CRM-Version-2.1.accdb
0
Comment
Question by:lehi52
2 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 39848075
Hello lehi52,

Change the combo box properties as shown in the attached image.

Sincerely,

Ed
combo.PNG
0
 

Author Closing Comment

by:lehi52
ID: 39848089
Awesome Thanks.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
type of query 11 42
How to use VBA to update a record in a table in MS Access? 12 36
Access Delete Query Not Working 13 28
Switch 5 16
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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.

772 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