A
AccessHugh
I wish to copy the previous value of a Number Field and then Add 1 s
that when entering data the new record automatically enters th
previous +1
eg 12345
12346 etc
This is to allow for easy enrty of serial numbers but occasionally t
change the root number and start a new series
Can anyone give me the coding to do this?
I am able to write simple vBA Code by copying but am not confident
originating same so please treat me as a raw beginner.
Thank
that when entering data the new record automatically enters th
previous +1
eg 12345
12346 etc
This is to allow for easy enrty of serial numbers but occasionally t
change the root number and start a new series
Can anyone give me the coding to do this?
I am able to write simple vBA Code by copying but am not confident
originating same so please treat me as a raw beginner.
Thank