Must Populate Fields in Subforms - Access 2003

[jdph40]

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 txtCorrectiveAc tion, cmboEmployeeNam e, 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 txtCorrectiveAc tion, 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

[rkc]

jd****@yahoo.co m wrote:

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 txtCorrectiveAc tion, cmboEmployeeNam e, 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 txtCorrectiveAc tion, 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?

You can loop through a forms control collection, identify subform
controls and obtain the control's form object like so:

Dim c as Access.Control

For Each c In Me.Controls
If c.ControlType = acSubform Then
'pass c.Form to a validation routine
End If
Next