Lafayette,
this is a very common thing to do. The usual way is to have combo box on the
form ( can also use a listbox).
The combo box has 2 columns, the 1st column is hidden and contains the
number corresponding to each choice.
The combo's row source is a query, table or a value list.
In your case you might have a value list if only a couple of choices. It is
easier to use a table if there are several choices.
So you might create a new table with 2 fields, the 1st field is a number,
long intereger, default value leave blank - name the field ChoiceNbr
the 2nd field is text, name it Choices. Save the table as tblSurveyChoices.
In the table enter your data with the numbers in ChoiceNbr and their
matching descriptions in Choices.
The combo box on your form has tblSurveyChoices as its row source.
Set up the combo box on your form so that when a user selects 'strongly
agree', the form stores the number 7 in the database.
This long description is only half of the process, you need to set up the
main table that records data in a way that in can store the number selected
in the combo box. This gives you the idea, but not all the info you need to
make it work. See the sample databases on ComboChoosesRecord.mdb (
beginner )
This illustrates how to have a combo box in which you can choose a value and
have that record appear in the form. at
http://www.rogersaccesslibrary.com/download3.asp?SampleName=ComboChoosesRecord.mdb
to see how this all works.
Jeanette Cunningham
