Using list boxes in a form to fill fields

[Guest]

I have a form based on a table which is to store performance data. The user
clicks on the control to select a number which I want to store. I have
several such list boxes on this form. On the form I use a text box to total
the sum of all numbers selected (think of a grading form). When I click on a
"save record" control button, none of the values selected are saved to the
record nor can they be retrieved.

How can I use the form to grade the employee's performance using list boxes
which have a data source of a table with the values and save the evaluation
for analysis? Also, how can I limit the summing to only that specific
record? Finally, how do I reference the text box that totals the fields to
draw an average or other calculations?

Thanks for any help on this question

 

[Arvin Meyer [MVP]]

You must bind the listbox to a field in the underlying table that is the
recordsource of the form. You do not need to save the total, just display
it. To do that, use a footer on the form and set its controlsource to:

= [ListBox1]+[ListBox2]+[ListBox3]

All the listboxes must have a value because Nulls propogate (1+Null=Null) so
if you expect Nulls use:

= NZ([ListBox1])+NZ([ListBox2])+NZ([ListBox3])