Auto Increment Number

[Rusty]

Can I make Access Auto Increment a 4 digit number at the next blank form. ie

When I start the secession I will type in the Visual Id #, say it is "7643".
Then when the record is saved and a new blank one opened, I would like the
form to open with a 7644 number already in the "VID" field.

 

[BruceM]

For one method (watch out for line wrapping in your newsreader window):
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb

 

[Rusty]

Where do I put that code. In the Lookup section of the Table or in the form?

 

[BruceM]

The link I sent contains this information. It goes into the field's default
value, which can be set in the text box bound to the field.