how to auto serial No start from 1

[rehanemis]

Hi,

I am working in ms access database form. I have a form with detail section. In detail section i would like to make sr.no field auto increase each time new quotation is created. Using AutoNumber didn't work because because it doesn't start the serial number from 1 for each new quotation.

Snap shot is also attached.

I am looking for kind suggestions in this regards..
Thanks

 

[bob fitz]

I would suggest using Nz(DCount(),0)+1 in the subforms Before Update event. You would need to use the field that links the two forms in the criteria argument of DCount().