how to change drop down box options in form without affecting the table

[jmb867]

Hi,
I'm a new user of Access and I'm required to input a survey into access. The data collected is being analyzed afterwards and therefore there cannot be any alpha content in the original table so I assigned multiple choice options numbers to correspond to the answers. In form view however I need the drop down boxes to spell out the answers, not just the numbers so the interviewer can read them out, I've seen this done on other similar surveys... Just wondering if anyone knows how!
* I also tried going into form view and editing the drop down choices but that changes the table values.

Thanks!
Jess

 

[GinaWhipp]

Perhpas this will help...
http://www.rogersaccesslibrary.com/forum/at-your-survey_topic3_post3.html

Side note: For a more specific answer it would help to know how your tables are set up and, if you using a Continuous form (which would present a problem it itself).