need user friendly form

K

Kim Doe

Joined
Jul 5, 2005
Messages
10
Reaction score
0
Hello...

I need a user friendly form, but a stats friendly table. Is there a way 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 a look-up table corresponding the text to number. Yet, playing around with it all morning, I can only get the table to reflect exactly what is entered in the form.

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

Thank you in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data entry for a table from a form 2
Separate Form 0
Tailor a form to enter vriable records 5
Prevent Duplicate Form Entries 0
Text Box with ability to enter the user friendly 'looked up' value 3
Combo Boxes and storing both columns 3
Data from a form populating a table 1
Data entry to table from a form 1

Top