What is the best way to program a cancel button?
on my form, I have several controls that the user would fill out about inventory assigned to an employee. most of the controls are combo boxes with a text box for quantity. If the user gets to some point in the process, but decides they made a mistake, I want them to be able to click one button, and have all of the boxes cleared out, and go back to the beginning.
the way I have it set up now, everything clears, and no record is added to the underlying table, BUT the table also seems to burn an autonumber for the record that was canceled. so, the next valid record added would be the previous record +2. It isn't a huge deal, I know that record number isn't truly important and it only needs to be unique, but for clarity purposes and such, I would just prefer if the numbers were consecutive.
is there any way to cancel inputting a record and NOT have Access burn off an autonumber?