I'm using MS ACCESS for my dbase..
i have a tblborrow where you can find transac_num ..now, i have in my form a label which here, you can see how many transactions you have done already(i'll name it sa lbltransacno) and a save button..
what i want now is that.. every time the user save a transaction.. the lbltransacno will automatically go to its next number.. but of course.. the user should fill up the information needed.. if those are not filled up, and he click the save button.. the transaction will not be counted..
how to code it??