Hi!



I'm pulling together a database that's a bit out of my weight class - new to Access, etc. - and I have a bit of a question.

What I would like, ideally, is a "required" field in a subform that is not really "required" - I would like the user to be able to click around inside the subform freely, without having to fill in this field immediately once they had entered it. However, when the user attempts to leave the subform, or to tab to the next record - if they have not filled in this one field - I would like a dialog box to pop up, informing them that if they do not fill in the field in question their record will be deleted. Then, if they say "OK," I'd like the record deleted (in the subform, not the main form).

I'm trying to put this in the subform's "AfterUpdate" field,

The required field is "CIDFile#" - the Subform name is "Follow-Up Subform".

Any ideas? I've tried a half-dozen approaches, but to date all have failed - I won't inflict my abysmal attempts at coding upon you here.