View Single Post
  #1  
Old November 6th, 2009, 06:51 PM posted to microsoft.public.access.forms
Rob M[_3_]
external usenet poster
 
Posts: 4
Default Required data on subforms

Hi group,

I have an Access parent form with two subforms. I'm wondering whether
there's a way to "force" people to enter data on one field in each
subform, or else not save any data (parent data included) at all.

If it's relevant, the parent form is supplied by a query. Each
subform is supplied by its own table. Each table is linked to the
parent query by a unique primary key.

I'm able to detect incomplete subform data using the BeforeUpdate
event on the parent form. But I'm not sure what to do from there.

I'd be very grateful for any help!

Thanks,
Rob