Disable how Access automatically saves forms into table...

[Adamowski]

Hello,

I am currently using Access 2007 on an XP laptop. I have a table and a form used to add records to the table.

I have noticed that if I close the form without filling out all of the information in the form, the form data is still written to the table as a record. Since the person using this form may have to unexpectedly close the form, how can I disable this functionality? I do not want incomplete records being saved to the table.

Thanks!

[missinglinq]

I always go into Design View for the form, under Properties - Format set Close Button to No, then put my own close button on the form. Then use spmething like this:

Private Sub CloseFormButton_Click()
If Me.Dirty Then
  resp = MsgBox("Do You Wish to Save The Last Record Added?", vbYesNo,  "Save New/Edited Record?")
     If resp = vbNo Then
       Me.Undo
     Else
       Me.Dirty = False
     End If
End If
DoCmd.Close
End Sub

This way Accesss will check the record to see if it's Dirty, then give the user the option to either save or discard the new record.. You should also be aware that at times, if a required field is not filled in, Accesss will Exit and not Save the record!

Linq ;0)>

[Adamowski]

It worked great. Thanks!

[missinglinq]

Glad we could help!

Linq ;0)>