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.