Reset Autonumber Field programatically

[Me]

Hi everyone!



I’m having serious problems with autonumber fields.

When users delete some records on forms or tables, total number of records
is reduced but autonumber field doesn’t consider it .

Users tell me: customers table has 100 records but the ID field(Autonumber)
is 125

This is because 25 records have been deleted.

Is there any way to reset the number of autonumber field on forms
programatically where necessary?



Best wishes

 

[Scott McDaniel]

Answered in another newsgroup.

If you feel the need to send this message to more than one newsgroup (and
that's rarely necessary), then Multipost instead. That way, answers given in
other newsgroups will show up in ALL groups.

 

[Scott McDaniel]

Sorry, that should be: you should Cross-post and NOT multi-post.

Too early and too soon after New Year's Eve!!!

(thanks Arvin)