How to number after specific number

[ghost]

Greeting,

I want to input a number in text box and after that access will add +1 for
each new record based on the number I specify. How to do that?

Thank you

 

[Maarkr]

many examples if you search the group on this topic...including
http://www.rogersaccesslibrary.com/download3.asp?sampleName=AutonumberProblem.mdb

 

[Al Campagna]

ghost,
Create a Default Value for that field...
= NZ(DMax("[NewCustID]","tblCustomers"),0)+1
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."