need user friendly form

[Kim Doe]

Hello...

I need a user friendly form, but a stats friendly table. Is there a wa
to allow users select words from a combo box in the form (yes, no
missing), but have numbers pop up in the table (-1, 0, 9)? I created
look-up table corresponding the text to number. Yet, playing aroun
with it all morning, I can only get the table to reflect exactly wha
is entered in the form.

I've also considered using check boxes in triple state, but I need t
have the null appear as "9" in the table, NOT a blank cell.

Thank you in advance

 

[Douglas J. Steele]

Create a table with 2 fields (an Id and a Description) and populate it with
3 rows:

-1 Yes
0 No
9 Missing

Use that table as the basis for your combobox. Set the Column Count to 2,
the Column Widths to 0 and the Bound Column to 1.