Assigning values to table

[jmr9999]

Hi Guys;

I am trying to create a survey form, and have not had success with the following: In the database, four questions are asked in the form of combo boxes. The answers are: Excellent, Good, Fair, Poor. Ultimately, I want to create reports for scoring based on these scores. I can put field type Number for the scoring fields, but the combo box no longer is alpha, and only lists 1,2,3 and 4. How can I get the numerical fields (which make it easier to create scoring) to display my answers (Excellent, Good..etc) in the combo box, and assign the appropriate values (1,2,3,4)? Any suggestions would be appreciated.

 

[THoey]

Been a long time since I have done this, so I remember it VERY vaguely.

1.  Create a static tables that contains your possible values.   This allows you to add or subtract from your possible values.   Two columns:
   Text         Value
   "Excellent"  1
   "Good"       2
   "Fair"       3
   "Poor"       4

2.  Create the list box based on a query of that table that selects both columns.   Show only the "Text" column by setting the second column width to zero.

3.  This is the part that is vague.   I believe you set the record source to the "Value" column.

LIke I said, this was a while ago that I did this, but it should get you started until someone else can come by and refresh my memory. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[jmr9999]

I'll give it a whirl. One of my problems was I created a lookup box with a key, a value, and the text, but I could not update it when I went to form view. In this form, I am also pulling data from an OBDC connection based on Sales Rep. I'm not sure if this complicates things, but it is not allowing me to update the form.