Required fields on a form

[cebrower]

I have a form with a number of fields that are defined as Required in the table definition. The form has a button that closes the form (DoCmd.close acForm, "Formname") but when I click that button the form simply closes without saving the record even though I've entered data in some fields and without warning that there are required fields. If I close the form by throwing it into design view I get the warning and the option to return to the form or to close without saving. How can I get the warning when using the Close button? I've tried setting warning = true, but no joy.

[Bob Fitz]

Have you bound the form and its controls (forms don't have fields) to the table/query?

[Welshgasman]

You could use

If Me.Dirty Then Me.Dirty = False

in the close event of the form?

[orange]

Also, check the Similar Threads at the bottom of the page.

[cebrower]

Thanks for all the replies. I've learned that the default value for required fields must be left blank in the table definition and in the control properties when the field is added to the form. In addition (and this one had me stumped for a while) if there are fields marked required in the table definition but not placed on the form and the data source for the form is the table itself Access will report that there are required fields left blank when you try to close the form.

[Micron]

if there are fields marked required in the table definition but not placed on the form and the data source for the form is the table itself Access will report that there are required fields left blank when you try to close the form.

Which makes perfect sense. Just because you don't add a required field to a form (which would be odd) doesn't mean that the fields validation is ignored. BTW, it would not matter if the recordsource was a query (instead of a table). Same result because the record is regarded as a whole.

[cebrower]

There were fields in the table that were not added to the form because I had created some fields that I later discovered were not needed. They are gone now.