Make auto number

[sanos_a]

Hallo friends,
I'm new on the forum and have some problems. I want to make field in the table to be something like autonumber but not to be AutoNumber. The filed must be Number but always to encrease next record in the base.


For example: I put number 4 on the record and now access to put number 5 on next record. How to create that?
Thank you

[RuralGuy]

This link may help: http://www.baldyweb.com/CustomAutonumber.htm

[sanos_a]

when i click to new to put new record in the base i need do increase number for example: last number is 2854 and next shoud be 2855.
i have no idea how i could to it.

[RuralGuy]

Did you look at the link I posted?

[sanos_a]

Did you look at the link I posted?

yes i look link but i solved on another way
thank you ruralguy

[RuralGuy]

Great! Would you care to share your solution with others that will read this thread and could benefit?

[sanos_a]

i have field fabric_number and it should be like i write before.
on button for adding new record i add docmd.gotorecord , , aclast to go on last record in the table. after that on field fabric_number i add an variable I. so after this docmd.gotorecord , , acnewrec and after this fabric_number = i+1 and everything work just fine like it should work

[RuralGuy]

Thanks you. Do you want to go ahead and use the thread tool and mark this thread as Solved?

[sanos_a]

yes i want to mark this as Solved.

[RuralGuy]

Look at my 1st post in this thread and follow the link for directions on how to mark the thread as Solved.