Updateing Records

Hi and TIA! I have a form were the using can reset the priority of the
record. I then want to add or subtract 1 from the other records depending
on what they change it to. Example:

Form
TypeModel Priority
A 1
B 2
C 3
D 4

If they change C to 1 I want to add 1 to A and B but not D
If the change B to 4 I want to subtract 1 from C and D but not A

Any sugestions would be appreciated. Thanks for your time!


--
Reggie
----------