B
Bill H.
Working on a form for families.
I have a parent form with the parent's info, and a linked subform with the
Child's information. Of course, multiple children may be input for one
parent.
On the subform, I check for certain values to be entered, like the child's
first and last name. If they don't enter those values, I display a message
that says they have to enter it. The values are vbokonly.
But, if they click on the cancel button of the msg, and then move to another
record, the "bad" data on the subform gets written to the table.
How do I prevent the user from moving to the next (primary) record until all
the conditions on the subform are met?
Thanks!
I have a parent form with the parent's info, and a linked subform with the
Child's information. Of course, multiple children may be input for one
parent.
On the subform, I check for certain values to be entered, like the child's
first and last name. If they don't enter those values, I display a message
that says they have to enter it. The values are vbokonly.
But, if they click on the cancel button of the msg, and then move to another
record, the "bad" data on the subform gets written to the table.
How do I prevent the user from moving to the next (primary) record until all
the conditions on the subform are met?
Thanks!