Steve offers a cogent point. If your PINs are sequential, and if I have a
PIN, what's to stop me from trying out the number before and after mine?

Are you confident that folks wont be able to use brute force to try all
10,000 possibilities? Are you confident you'll never have 10,000 PINs to
generate?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Rev David Bissas" Rev David wrote in
message ...
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.