sequence Lot no

[carl024]

Data of table

Lot_no............Product
01.......................aa
02.......................bb

for example delete lot_no 02
Lot_no............Product
01.......................aa

i need when insert new data in form lot_no runing auto serial
lot_no start is 02

give some tips file attach

 

[John Big Booty]

Perhaps the discussion and samples here will give you some pointers.

 

[carl024]

i check your link and file work best but
i change some thing in file and need use as unbound counter in form
and counter run auto to next record
guide for me