On my form I have a tab control that contains 12 subforms. The
child/master field that links the main form to each subform is
IncidentNo. Each subform is used to record a corrective action that
needs to be taken when an incident occurs. The user must enter the
corrective action in a text box, then choose from a combo box the name
of the employee who is assigned the task of completing the corrective
action, and in another text box, assign a due date the task is to be
completed by.
So I've got subforms named sbfrmCA1, sbfrmCA2, up to sbfrm12, each with
fields named txtCorrectiveAction, cmboEmployeeName, and txtDueDate on a
tab control named tabCtlCAs. What I'm trying to accomplish is that
when the user clicks a button to close the main form, if he entered
anything in txtCorrectiveAction, he must have populated the other 2
fields in the subform. If he left one or both of the fields empty, I
want a message box to pop up and let him know what he's left undone on
which subform. How do I "cycle" through each subform to verify that he
entered all 3 fields?
TIA,
JD