Is there a way to change the value in a autonumber field ?
the autonumber changes everytime you add a new record, but if you are decide to cancel entry in a new record. the autonumber value still increases by one is there anyway to prevent this
