Verifying Info In Subform

[Guest]

I have a yes/no checkbox on my main form. This yes/no checkbox is to indicate
if there are any safety violations. If the user selects "yes" a subform is
enabled for the user to select the violations. The problem I am having is
when users select "yes" they are not selecting at least one violation from
the subform. Is there a way to use the Parent Form_Before Update to make
sure the user is completing the subform.

 

[roadie.girl]

probably the easiest way to do this is just to put a default if no
violations are checked, to select all. if the user doesn't select any
violations, then haev a messagebox popup that says "selecting all
violations...."
that way you don't have to add a new function (or sub) but you're just
appending to the one that displays the violation information.

make sense?
hth

 

[Guest]

No, it doesn't make sense. The subform has a combo box which the user can
select one or more violations. The problem is they are indicating violations
by checking the yes/no checkbox but forgetting to select one or more
violations in the subform and closes the form without realizing their
mistake.--
Thanx!