Search results

Hi Mstef thanks for the response. It seems to do the job by incrementing the right field but every time I do it it doubles the number of records it adds ie first run = 2 records added, then 4 , then 8 My Field contents are:Serial: Nz(DMax("[ProductTbl]![StartNo]","producttbl"),0)+1

I have searched and found many references to DMAX but I haven't found the answer to my query which I imagine is basic. I have a new DB for listing serial numbers on manufactured products. I need a unique autonumbering system for incrementing a 4 digit number starting at 1000. I can make DMAX add...