I have a form which has a table as its record source. the form also has a sub-form. If the user enters data in the main form and then does not enter any data in the subform we have the record being deleted when the form is closed. This is by design.
But then of course the record number is lost and the next record number skips over the deleted one. We don't want to have the record number skipped.
Can this be done somehow?