Automated numberings

[Guest]

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

 

[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.