Access once again

[aceizace]

I'm having problems with my Autonumber, if you type in some info, then press enter, then delete the field, the autonumber acts as if it was still there. Is there anything you can put in the expression builder to mean 'last entry'. Hope that makes sense and thanks.

[rinkytink]

When creating the record the auto number will be say 10, if you delete that record and create a new record the next number will still be 11 - even though you no longer have record 10. Is that what you mean ?

If so then I am not aware of any way around this. Every time you want the number sequence reset you have to go into the tables design, delete the auto number field, save and close. Go back into the tables design and put the auto number field back in and save.