I am new to access myself, but I do know enough to say that if you adopt the
autonumber setup it would work better for you. However, do not skip numbers
when building your database. The reason for this is that when it comes time
to query your data into reports and forms, if you skip numbers it could cause
problems pulling in the data that you want.

"Rev David Bissas" wrote:

I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be appreciated.