Increase by one

[LOIZOS]

Hi,
I need your help.

I have a subform with the following fields

Account_NO , Cheque_No , DR ,CR

I want the Cheque_no to increase automatically by one from the second record.

Thanks

[pbaldy]

Often the DMax() + 1 method is used:

http://www.baldyweb.com/CustomAutonumber.htm