I am trying to use a form to allow a person to generate a new record. There is a field that is an autonumber. The forms works fine except if someone enters anydata and then decides not to save it then the autonumber still progress to the next number. How do I reset the autonumber? I am using an if dirty statement to see if data has been changed and then if the user does not want to save changes the code converts everything back to the origional, but this does not work for autonumbers for some reason.
Chris
Chris