Cancel when there is a required field

[dougie]

I have a form with a subform. The subform has as its datasource a table with some required fields. If the user accidentally enters a new record on the subform (which can be done simply by pressing a key in the new record row) it seems to be impossible to cancel out of this - the 'required field' messsage pops back no matter what you do. I've tried me.undo, me.subformname.form.undo but so far nothing works. Any ideas?

[pbaldy]

If memory serves, the required field error can be trapped in the form's error event. Is that where you're trying this?

[dougie]

Yes. Sorry to waste your time - problem seems to have been caused by a corrupt form - there was nothing wrong with my VBA. Very annoying.

[pbaldy]

No problem, glad you got it sorted out.