I am trying to do a check processing function and I get to the point where I need to assign the check number (starting with a check number keyed in by the user)then automatically assigning the next check number to each check record found to have no check number in the query. What I essentially want it to do is start with the first check as number 10001, the next check is 10002 and so on. Is there some way to utilize the Record Number that displays at the bottom of the query to do this - EX. [START_CHECK_NUMBER] + RECNO()-1 ?

This would work but I don't know how to access the record number and use it.

Max([CheckNo])+1 or something similar. Your record count will not likely equal your check numbers (example: VOID checks or blanks in your autonumber sequence).

HTH,
David R