<div>
FYI: once an autonumber value is reserved for a new record, it is totally unusable. &nbsp;If you delete the new record, or otherwise dispose of it, that number will not be reused by Access. &nbsp;It will not matter if you have saved the record or not...Access increments the seed at the same time it provides a specific value to a new record.
</div>


FYI: once an autonumber value is reserved for a new record, it is totally unusable.  If you delete the new record, or otherwise dispose of it, that number will not be reused by Access.  It will not matter if you have saved the record or not...Access increments the seed at the same time it provides a specific value to a new record.

<div>
Thanks. &nbsp;Exactly what I needed.
</div>


<div>
<div class="content wysiwyg-content">
I have a form that uses an autonumber field. &nbsp;When a new record is created, the form shows &quot;autonumber&quot; in the field. &nbsp;Only when I start to enter data in another control on the form, does the autonumber field actually display a value.<br />
<br />
I would like to use the autonumber field when I generate a new record to create a Ticket Number (the TicketNo field is a test field that is a concatenation of a couple of fields including the autonumber field).<br />
<br />
Does anybody know how I would go about using the autonumber field immediately upon creating a new record in the form? &nbsp;I have tried adding VB code to the OnClick event for a &quot;New Record&quot; command button to no avail.<br />
<br />
Thanks in advance.
</div>
</div>


I have a form that uses an autonumber field.  When a new record is created, the form shows "autonumber" in the field.  Only when I start to enter data in another control on the form, does the autonumber field actually display a value.

I would like to use the autonumber field when I generate a new record to create a Ticket Number (the TicketNo field is a test field that is a concatenation of a couple of fields including the autonumber field).

Does anybody know how I would go about using the autonumber field immediately upon creating a new record in the form?  I have tried adding VB code to the OnClick event for a "New Record" command button to no avail.

Thanks in advance.

Autonumber Increment Event

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.