Need textbox in form to reflect data in table

[kcortina]

Hi,


I am creating a form for QA purposes and I need the scores to be saved into a table. I have 3 "score types" (Rockstar / Professional / Learner) and I have created a textbox with the expression =IIf([CmbLS]="Rockstar",10,IIf([CmbLS]="Professional",5,IIf([CmbLS]="Learner",0))) in order for a numbered score to autofill based on the score type selected, however since this is entered as the control source, these numbered scores are not saving into the table under field I've titled "Points_Listening" and I need them to in order to avoid human error. Any help with this would be greatly appreciated!

[pbaldy]

I'd have a table with the cmbLS values and the associated numeric values. Then use this for display:

http://www.baldyweb.com/Autofill.htm

[ranman256]

If you put these names/values in a table,you won't need IIF statements.

[kcortina]

I'm not quite sure what you mean. The names themselves are populating into the table through combo boxes.

[pbaldy]

Rather than hard coding the values into a formula, they should be in a table. Much more flexible and dynamic, and you can use the method above to display or populate the values. If you resist that:

http://allenbrowne.com/casu-14.html

[kcortina]

I'll try this. Thank you!

[pbaldy]

No problem, post back if you get stuck.