Printing Checks from Access 2010

[howlettb]

Hi. We are a non profit agency that handles a representative payee service for several people. I've created a database that keeps track of the banking account for each of these consumers. I've even made a report that prints out the checks for bills that need to be paid. The problem I'm having is creating a check number that increases by 1. (Example: Check 101, 102, 103). I can do this is a report ... but I need the check number to get saved into the database once it's created. Does anyone have any idea how I can do this??

[ranman256]

in the table you have [checkNum]
click button to open form to add new check
docmd.openform "frmAddCheck",,,,acFormAdd

in the ON LOAD event of the form, fill the checkNum textbox with the next number,

txtCheckNo = DMax("[checkNum]","tChecks") + 1

[howlettb]

Will this work if you are running a page full of checks. Our checks come 3 to a page, and we set it up to run them all at once.