I am looking for some code to assist me automatically enter a new number consecutively in a text box. Example. I enter a class number in a text box and when I press enter a query and a macro puts the consecutive exhibit number in the adjacent text box. To get this to work I had to set all the exhibit numbers in the field to 1. If an error is made when you enter the class I have a command button opening an input box asking for the class to be amended. This then displays a form which will allow the record selector to be used to delete the incorrect entry. Now I must manually change the exhibit number to one less than displayed so that further entries in that class remain consecutive. The code I am looking for hopefully make it easier when deleting an incorrect entry. Sounds a bit messy but what I am trying to do is to improve something I already have. Thanks