Database has multiple data entry forms. If an individual were to be working with a form, enter a little bit of information, or even leave it blank, and then close the entire database without closing the form first, it creates blank, or incomplete records in the table.
I would like to either have a general database "closing procedure" where it closes all open dirty forms without saving the record. Or prevent the individual from closing the database without first closing the active form(s). Not sure what the best way to go about this is, so any help would be appreciated.
I've managed to track down the reason why I get blank and incomplete records.
My form has a couple of procedures that populate certain fields when the form opens. If I delete these procedures, then it doesn't save a record no matter what I do, until I hit the save record button.
My guess is I have to make these fields null on unload. Or delete the record somehow.