saves data with out click "Save" button in forms

[terrythomasvda]

hi,
how to stop access saves data with out click "Save" button in forms. in my form i have "Save", "close" and "Home" button which i created from control wizard, when ever i click any button or close my form data saved in my table. i want only to save when i click "Save" button.


as per one of ur previous comment i enterd below code in the mail form after that it is not saving any data in table even i click "Save" button.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Not Save Then
Me.Undo
End If
End Sub

[June7]

Record is committed to table when form closes, move to another record, or by code. I don't understand 'If Not Save Then'. What is 'Save'? You are trying to detect if it was the Save button that was clicked. Never seen any code for that. I used Cancel and Save/Close buttons on my form. If user decides to Cancel data entry then code in Cancel button undoes the entries and record is not committed.

[terrythomasvda]

Record is committed to table when form closes, move to another record, or by code. I don't understand 'If Not Save Then'. What is 'Save'? You are trying to detect if it was the Save button that was clicked. Never seen any code for that. I used Cancel and Save/Close buttons on my form. If user decides to Cancel data entry then code in Cancel button undoes the entries and record is not committed.

"Save" the command button which i user in the form and in the form i am not using cancel button.

[June7]

Believe I understand what you are doing and I am suggesting that is not practical, hence the description of what I do is offered as an option.

[roaftech]

I reiterate what June7 says - better to use the wizard to create a Cancel button and then you know the code is going to work. You can set the Cancel button to be the default if you wish.
Otherwise you are into writing modified code for all your "non-saving" buttons, which introduces unneccesary complexity and, as you have found, a high likelihood of unanticipated errors. Remember, the software does only what you specifically tell it to - not what you think you told it.