troubleshooting Question

Access 2016 - combo box

Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America asked on
Microsoft Access
3 Comments2 Solutions195 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros