Hi
I'd go with option 2 every time.
Double click ComboBox1 in the VB editor and use

Private Sub ComboBox1_Change()
ComboBox2.Value = 100 - ComboBox1.Value
End Sub

You could allow edit in both boxes by doing the same sub for ComboBox2.

regards
Paul

If they are combobox1 and combobox2 then
(Nikki) wrote in message . com...
Hi

I have two incremental counters on a form where users can enter two
scores (home and away). I want to limit the total of the two scores to
100. I'm thinking of two options and would appreciate any help with
how to do it.

Let's assume the total of the two scores is currently 100 and the user
clicks on the up arrow to increase the home score by 1, the options
a

1. The home score doesn't change and an error message appears asking
the user to reduce the away score first.
[On this one I don't know how to stop the home score increasing. The
score continues to increase within its own parameters.]

or

2. The home counter increases as the user clicks the up arrow but the
away score decreases to maintain a maximum total of 100.

Win2K XL2K

Many thanks
Nikki