For some reason, on exit from my application when the user uses the X at the top right and the values in the text boxes are blank Access will enter in an empy row in the table. This will happen repeatedly. Is there a reason for this and what can I do to stop this from happening? It's very frustrating so anything you can do to help me I'd greatly appreciate it. Thanks.
When the user closes the form with the fields empty but Access is still open it leaves an empty record and it'll do this infinitely, it seems, which is an obvious problem. I don't want like 30 blank rows with 45 good rows of data, obviously.
you might want to disable the default close button of the window and implement your own close button in the form. and before closing check if record is dirty, if it is undo record before closing the form.