Programming of 'SAVE' button in Access 2010

[THE STUDENT]

Good day all, im currently in the process of attempting to achieve validations for my customer form, one of the issue that I just cant seem to resolve is getting my save button to function properly, meaning that once data is on the form that already exists within the database and should the user click save nothing should happen or maybe a message pop up saying that the function cannot execute. The only time the button should function is when there is new customer data (when the 'Add New Customer' button is pressed) and after the details saved a msg confirming such. Im not to good with the use of code as im trying to fix this using the form and button properties but to no avail.


Can anyone advise on how to achieve such, and if possible is there anyway to make the button solid and only when the 'Add New Customer' button is pressed it will then initialize?


Please Advise


The Student

[mike02]

on form open even type this

Cmd_Save.Enabled = False

Then on the code for New customer type this underneath it:

Cmd_Save.Enabled = True

Note: Assuming your save button is named Cmd_Save
Hope that helps,

[THE STUDENT]

can u be abit more clear michael, im I doing that within the VB code page? and if I should change the save button to false will if not become dis-functional?
Im new to access, hope my questions are not dumb

[Bob Fitz]

Record validation should be done in the forms Before Update event because that event always fires, as its name would suggest, just before the record is saved. In that event the update can be cancelled if the validation fails. The only code you need for the "Save" button would be something to make the record update. Something like:

If Me.Dirty Then
  Me.Dirty = False
End If

I would not bother with a "Save" button. IMHO it serves no real purpose. When the user does something to close the form or move to another record Access will automatically save the the record and the forms Before Update event will fire.

[THE STUDENT]

This is being done for an assignment Bob, so I cannot exit the form without saving the info first during my presentation, that would be poor coding on my behalf, I really need this to function with the save button and i need that button to function only when new data is on the form

[Bob Fitz]

Then use the code I gave in post #4