Good morning,
I am using Dmax to create a unique sequential numbering in a form. I would like the first entry to start at 1, however it keeps starting at 0. I tried changing the default value in the table design to 1, but it keeps going back to zero.
I put the below code in the forms Before Insert event
Any suggestions on how to start at 1?
Thanks in advance for your help
I am using Dmax to create a unique sequential numbering in a form. I would like the first entry to start at 1, however it keeps starting at 0. I tried changing the default value in the table design to 1, but it keeps going back to zero.
I put the below code in the forms Before Insert event
Code:
TaskNo = Nz(DMax("TaskNo", "tblTasksDtls", "TaskID=" & [TaskID]) + 1, 0)
Any suggestions on how to start at 1?
Thanks in advance for your help