<div>
<div class="content wysiwyg-content">
I have a form linked to a table containing an auto number field primary field. Upon creating a new record via the form an auto number is generated. However, if the user decides to back out of the record and not save it the auto number remains incremented even though there will be no entry in the table. Is there any way to prevent this from happening or am I best off using code to generate my incremental number?<br />
<br />
Lee
</div>
</div>


I have a form linked to a table containing an auto number field primary field. Upon creating a new record via the form an auto number is generated. However, if the user decides to back out of the record and not save it the auto number remains incremented even though there will be no entry in the table. Is there any way to prevent this from happening or am I best off using code to generate my incremental number?

Lee

Reverse Auto Number field?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.