M
mcnewsxp
how do you loop throuhg the rows on a continuos form?
ala:
If TypeOf ctlCntrl Is SubForm Then
strForm = ctlCntrl.Name
For Each ctlSubCntrl In
Forms(strCurrentForm).Form(strForm).Controls
'''need to loop through here i suppose
If TypeOf ctlSubCntrl Is TextBox Or TypeOf ctlSubCntrl Is
ComboBox Then
Debug.Print ctlSubCntrl.Value
End If
Next ctlSubCntrl
End If
ala:
If TypeOf ctlCntrl Is SubForm Then
strForm = ctlCntrl.Name
For Each ctlSubCntrl In
Forms(strCurrentForm).Form(strForm).Controls
'''need to loop through here i suppose
If TypeOf ctlSubCntrl Is TextBox Or TypeOf ctlSubCntrl Is
ComboBox Then
Debug.Print ctlSubCntrl.Value
End If
Next ctlSubCntrl
End If