We help IT Professionals succeed at work.

Access 2016 - combo box

Last Modified: 2017-03-23
i have a Form and on it  there is a combo box field.  The Form's table is tblCredit card
The data is picked from another table named tblCard Types.  Card types are like  Visa, MC, Amex and this table has only 2 fields, the ID field which is numeric and the card type field which is text.  Thus the data would be
1   Visa
2    MC
3    Amex

When I select the data from the combo box it is saved into a field in the tblCreditcard.  Although in the combo box I only have the field the Card type, thus allowing me only to select one of the 3 data  as above, but when after selecting I look at the table tblCreditCard, the data is entered as eg ; 1 and not Visa
Looks like I am doing something wrong but I do not what it is, hope the experts can please advise me.  thank u
Watch Question

Top Expert 2016
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)


I like Rey's solution, as in one stroke, it solved the issue.  Thank u

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions