Saving Records on a Form

[Malc8179]

Hi Guys
I have a access form that is bound to a table when the users make a change in a field on the form and move to the next field or record the record is saved, the users have asked if this can be changed so they have to click a save button to commit any changes before they can move to the next record.
Is there an easy way to make this happen or will i have to unbind the form?

Thanks

 

[Remou]

How about adding a message box to the before update event?

If vbYes<>MsgBox("Save?",vbYesNo) Then
   Me.Undo
End If

Note that this will be an annoyance if you have subforms.

 

[Malc8179]

Thanks this helps

is there a way i can tell the state of the record ie if no changes have been made what is its state, i than can add an save button and an if statement to the code above saying if no pending changes end sub

 

[Remou]

If Me.Dirty=False

Means that there are no changes.

 

[Malc8179]

Thanks for your help with this it's saved me a lot of aggro