"Do you want to save the record?" message.

[dawkirst]

Certain fields in my form are required before a record can be saved. I have a "save record" button and a "quit form" button. When the form is quit before a record is saved, all data entered into the form are lost.

This resulted in people entering data that were never saved, because they are used to other databases where a record are saved even if they quit.

Is there a way I can prompt them with a "Do you want to save this record?" message when the form is being quit? (All required fields should still be entered before it can be saved.)

Thanks ahead.

 

[RuralGuy]

Maybe this will help.

 

[dawkirst]

Thank you. I'm sure it'll help.

 

[dawkirst]

What exactly does this code do? I need a bit of explaining to incorporate it into my form.

If Me.Dirty Then
    Me.Dirty = False
End If
DoCmd.Close acForm, Me.Name

Thanks ahead.

 

[jrjr]

Check this out too:
http://www.access-programmers.co.uk/forums/showthread.php?t=38364

 

[ghudson]

Check out these two links...

Enable/Disable The Control Box X Button

A better mouse trap?

The trick is you must use the forms BeforeUpdate event for any validations.

 

[RuralGuy]

Hi dawkirst,

If Me.Dirty Then
    Me.Dirty = False
End If
DoCmd.Close acForm, Me.Name

Though it does not look like it, setting the Dirty flag to false saves the current record. Many MVP's prefer this method over the more traditional code of DoCmd.RunCommand acCmdSaveRecord