Question about listboxes on a form

[greaseman]

On one of my forms, I have two listboxes. I can pick one or several departments from the left listbox, and using code and queries, can “move” the selected items to the right listbox. There is also a total cost text box on my form for an item being ordered. What I want on this form is to divide the total cost of the item by the number of departments selected. I had placed code behind the left listbox to calculate this cost, but then realized if one department was selected, yes one department paid the entire cost, but then if I went back and then selected, let’s say, 3 departments, the cost was figured over 3 departments, and not figured over 4 departments. Is there a way to retain the total count of departments that could then be used in a running total calculation?

Thanks!