How to enforce text fields as required in a form before saving or exiting or updating in MS Access 2010
Posted on 2013-02-05
I am building a DB in Access 2010. I am still new to DB programming.
On my forms I have various buttons such as a Save Record button, a Add New Record button and 2 navigation arrow buttons. When the client using the DB inserts data into the text fields and attempts to save or update the record, he must enter text into certain fields or cancel that process without saving any changes.
If the client enters data in an existing record or a new record without saving, I want to display an error message of some sort so that the client must enter data into the required fields.
I want to make certain fields required before saving the form.
Thank you in advance !