Auto Increment using default value when nil records in table

[BPBP]

I have an auto-increment textbox on a form used to generate id's for each record. the field name is [Job No] and Table is [QT Job Record].

I set the default value of this textbox on the form as = Dmax("[Job No]","[QT Job Record]")+1 for auto-incrementing.
This works fine, but However as I would need to empty the table every month, I would get an error when using this form/textbox if there is no record in the table after emptying it.

How do I go about solving this?

Thanks,
BP

 

[gemma-the-husky]

slight change

just use nz to trap the "no entries" case

nz(Dmax("[Job No]","[QT Job Record]"),0)+1

 

[BPBP]

thanks !