Each field is a lookup field that looks up the exact same data in another form.  I have them set to checkbox fields.

What I need is for them to be opposites as far as what they have selected.

Say for example I have them lookup the following data: (A, B, C, D)

So the form will look like this (the "X" will represent a checked box and a "O" will represent an unchecked box)

FIELD 1

X - A

O - B

X - C

O - D

FIELD 2

O - A

X - B

O - C

X - D

I'd like it so that whenever you check or uncheck a box in either FIELD 1 or FIELD 2, it automatically changes the OTHER field.  The purpose of this is to not only save time but also not allow you to choose the same choices for both fields, because that will cause problems.

Anyway, any help is appreciated and let me know if anyone has any questions.

John Ferguson