troubleshooting Question

How would I change the number from the combo box drop down choice that is saved in the MS Access Table?

Avatar of PDSWSS
PDSWSS asked on
Microsoft Access
7 Comments2 Solutions539 ViewsLast Modified:
I have created an MS Access 2007 database that contains many questionnaires (forms).
A small sample of this DB is attached. Please see YMRS table and form.
On several questionnaires I need to have the total of the answers saved in the Total Field in questionnaire (forms) and the corresponding tables.  A number is associated with each answer and this answer for each question is chosen from a combo box. Please see attached example from the database.  
The position of the chosen answer in the combo box is saved in the table and not the  # that goes with the answer. For example, if the answers in combo box are  0,2,4,6, a choice of  4  is saved as 3 not 4.  I would like to save the answer to the question not the # of the position in the drop down.  This is important because I need to calculate the total of all the answers.
For example, if answers to  Q1 =  4   and  Q2 =  6 then total = 10.  Based on position in dropdown Total now =  3 + 4 = 7.  You can see the problem.
How would I save the numerical  answer and not the position in the combo box in the table corresponding to each form?  Thanks,

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 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 7 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