Auto-increment fields update

[rkalapura]

Hai,
I have a transaction table and two corresponding forms for receipts and issues in MS Access 2010. Records are either "Receipt" or "Issue". I want to have an automatic update, (incremented by one) on "Receipt No" and "Issue No" fields (both are numeric, double) whenever I add a new record to this table. I mean when I add a new record of Receipt, Receipt No field should give the next sequence number and the same with issue records. I cant use autonumber because both are in one table. Is there any way I can use macro or vb code in the form/field events?
Thank you in advance for your valuable advise.
Best regards

[June7]

Common topic. Search forum and Google.

Check this recent thread: https://www.accessforums.net/access/...ber-20506.html

[ssanfu]

Hai,
I have a transaction table and two corresponding forms for receipts and issues in MS Access 2010. Records are either "Receipt" or "Issue". I want to have an automatic update, (incremented by one) on "Receipt No" and "Issue No" fields (both are numeric, double) whenever I add a new record to this table. I mean when I add a new record of Receipt, Receipt No field should give the next sequence number and the same with issue records. I cant use autonumber because both are in one table. Is there any way I can use macro or vb code in the form/field events?
Thank you in advance for your valuable advise.
Best regards

There are many ways to "roll-your-own" Autonumber primary key(s). Here is a link to a Rogers Access Library example:

http://www.rogersaccesslibrary.com/forum/topic395.html

or read this:

http://www.pcreview.co.uk/forums/cus...-t3726793.html

[rkalapura]

Thanks for your help. I refered Rogers Access Library examples. Actually I tried to use Max() function before, but it doen't workout. But after getting your help, I used Dmax() function in the default value and the problem solved.
Thank you once again for your help