ClaimNum is a number assigned by the accounting department to each new claim. They use the next consecutive number. The form is based on a query. When the form is opened, I want the ClaimNum field to show the last ClaimNum that was used plus 1 then append that information and the other information entered on the form to the table. Any suggestions?