Restart line number

[rixter67]

I have a field from a table called line number. Currently you have to type the line number in to fill the box. I would like to be able to populate this field and successive fields automatically. I thought AutoNumber would be the way to go, but it continues on down the line. Example: 2 different check requests would have line numbers from 1-8 instead of 1-4 and 1-4.

Any help is appreciated.

 

[ThomasLafferty]

Hi!
Can you explain this in a bit more detail?

Example: 2 different check requests would have line numbers from 1-8 instead of 1-4 and 1-4

Tom

Born once die twice; born twice die once.

 

[Remou]

Perhaps you could try DMax?

[tt]=DMax("LineNo","tblCheques","ChequeNo=" & ChequeNo) + 1[/tt]

However, getting the Cheque number may take a little thought, depending on your form.