Automated numberings

H

HoganD87

For each job there is a quote number (ex. 110701)

Everytime I add a row for a new job can the list keep going accurately?

ex.

PROJECT CUSTOMER Quote
Job A DynaTen 110701
TMC
DuctWorks
Job B Apple 110702
Job C Orange 110703


Step by step help please
 
A

Arvin Meyer [MVP]

Either start an autonumber with one less than the desired starting number,
or if you already have records, try using:

=DMax("QuoteFieldName", "TableName") + 1

as the DefaultValue property or the QuoteField textbox control in your form.
 
Top