I have a field on a form that I would like to automatically generate a number, in sequential order, each time a new record is created, and be stored in a field. The problem is that I do not want this field to be an autonumber field because if a new record is opened by mistake and then not used, the autonumber's field would not be in sequential order any more. Is there a way to do this? Maybe something along the lines of matching the actual record number that is displayed by the record selection buttons at the bottom of the page? Any ideas on this would be greatly appreciated. Thanks!