Auto-increase Field Value

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
auto number in query 1
Auto Number Fill 3
Auto Complete (auto fill) in Lookup Fields 0
Default Value & Data from another Table 8
Match/Duplicate/Auto fill certain fields from different tables 3
calculating incremental value contingent on other field 1
Access auto numbers 3

Top