Updateing Records

Reggie

Guest

Posts: n/a

#1: Nov 12 '05

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
----------

« previous question | next question »

Similar Microsoft Access / VBA bytes

Design Question (answers)
Trigger on Postgres for tables syncronization (answers)
Updateing a database table from a dataset (answers)
INSERT Cyrillic to Access DB via ASP ? (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.