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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"HoganD87" <(E-Mail Removed)> wrote in message
news:BD603096-ECE5-486F-B81E-(E-Mail Removed)...
> 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