Cancel Record with No Data Entered

[JenNorthwood]

Hi There,

I have a form that I wish to write code for. I want it to do the following:

If any fields in the form are blank, to cancel the record and not save anything.

I don't know code very well and I am unsure of where to start. Does any one have some examples of this? I have attached an example of what I am trying to do. I am sure what to write and where to put it.

Thank you.

Jennifer

 

[Pat Hartman]

You don't need to write code for this at all. Simply define the fields as required in the table and Access will not let you save an incomplete record. If you want to write some code, you can intercept the Access error message and replace it with your own. Place your code in the form's error event.