isn't this a dupe of this thread?
This is a discussion on do not allow record to be saved within the Microsoft Access forums, part of the Question Forums category; Is it possible to add code to the SAVE button (on a form) that will not allow the record to ...
Is it possible to add code to the SAVE button (on a form) that will not allow the record to be saved if there are records that already have certain data in the fields.
record to be saved is..
Mgr Project ReportDt Meeting and other fields...
Scott Dallas Jun06 yes
Mgr Project ReportDt Meeting
Scott Dallas Jun06 no
Dave Houston Jul06 no
Ben Austin Jul06 yes
Scott Dallas Jul06 yes
Therefore the record cannot be saved because this data (Mgr, Project and Report Dt, (Meeting and other fields are not part of the criteria)) already exists in table.
I need the record to not be saved and a message to change the report date.