S
scotia100
This question has been asked before but not answered so I thought I'd try
again:
I have a calculation that depends upon the selections of two list boxes....
Operating System x No. of Users = A Value
When a user selects from list box 1, then list box 2, the value is
calculated correctly. When they select a different number of users from list
box 2, everything is still OK. However, if after all this they should change
their selection from list box 1, the value does not recalculate.
You have to make a different selection from list box 2 to force the
calculation to take place.
Can I create a refresh button or better still set the form to re-evaluate
automatically?
Thanks for any help.
Scotia
again:
I have a calculation that depends upon the selections of two list boxes....
Operating System x No. of Users = A Value
When a user selects from list box 1, then list box 2, the value is
calculated correctly. When they select a different number of users from list
box 2, everything is still OK. However, if after all this they should change
their selection from list box 1, the value does not recalculate.
You have to make a different selection from list box 2 to force the
calculation to take place.
Can I create a refresh button or better still set the form to re-evaluate
automatically?
Thanks for any help.
Scotia