Controlling autonumber

[Patience]

Hi,



I have an autonumber field in my form. I use it to show next available number, when a new item/record is created.

When I start creating a new record (filling the fields with data) it shows the next number as it is supposed to. However, if I then undo all my actions, thereby leaving the form without saving the new record, then the autonumber field has still counted 1 number forward. Is there any way to prevent it from doing this?

So it only counts 1 number forward if a new record is actually made.

Thank you very much in advance!

[maximus]

This is a link to a thread that I think might help you.

https://www.accessforums.net/forms/a...pens-5235.html

[Patience]

Than you very much maximus!

I used the DMax function and it works perfect for me.

[maximus]

glad I could help you out.