Avatar of Jegajothy vythilingam
Jegajothy vythilingam
Flag for United States of America asked on

Access 2016 - combo box

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
Microsoft Access

Avatar of undefined
Last Comment
Jegajothy vythilingam

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jegajothy vythilingam

ASKER
I like Rey's solution, as in one stroke, it solved the issue.  Thank u
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck