Sir excuse me.. (sorry guys , i'm just a student here) I have a table with Transaction number. In my form I want to have that transaction number automatically adds up by 1 whenever I press the New Record button. What commands will I put before the Append Blank. The table and the fields are tblTransaction.transno . Hope you could help me with this . Sorry if I disturb you all..