"Delete Sent Patients" button

The "Delete Sent Patients" button on the Main Form (CCMDB.accdb) deletes patient records that have the Record field set to "Sent".

When patients are sent the RecordStatus field is set to "Sent". This allows keeping patients on file until it is clear that the sent was successful, while not getting sent patients mixed up with ones ready to send in the new round and have the RecordStatus field set to "complete".

Logical delete

The button implements a partially logical delete (i.e. parts of the record are retained but hidden instead of deleted). See RecordStatus_field#deleted for more info.