MS Access 2010 - Stop Table Update
Posted on 2015-01-13
During the addition of a new record I check for entry of data on a form in a non-key field. The User doesn't always access the field but needs to be forced to access / put data in the field. If the data is not supplied then I need to stop the writing of the record. I can detect the that the field doesn't contain data and issue a message but how do I stop the record being written without valid data? I'm currently doing the checking in the BeforeUpdate Event.
What I believe I need to know is how to stop the addition (writing) of a record or the updating of an existing record that is incomplete but has a valid Primary Key.