I am using "DoCmd.RunCommand acCmdUndo" on a button that closes my form to prevent blank or incomplete records from being added. The only problem I have is my UID is AutoNumbered, and everytime this button is pressed a UID gets deleted (ex. if users start to enter a record, then press the "Close Form", blank record does not get saved - GOOD - but the particular UID that would have been assigned to that record gets deleted - BAD - which throws the sequence off. If, for instance, user completes record 23, starts to enter record 24 but does not complete it and instead closes the form, record 24 dissappears completely and next time user will start at record 25.)
Is there any particular way to combat this problem?
Thanks in advance. Please let me know if this needs further explaining.