how to reference a subform within a subform

[pogs]

i have a form- frmCompany. It has a subform- subfrmExams. Then the subfrmExams has another subform within it- subfrmPackage. I opened the main form-frmCompany in hidden view using another Form.

I want to control the subform-- subfrmPackage, so that it would go to the next record. How do i do this using visual basic?

 

[boblarson]

perhaps this will help:

http://www.btabdevelopment.com/main...rhowtoreferencesubforms/tabid/76/Default.aspx

Read through it and further on down I reference how you can reference things at multiple layers using the shown syntax.

 

[Cosmos75]

bob,

Very nice article!

 

[pogs]

this is only for subforms, i have a subform within a subform.
could i docmd do?
Docmd.gotorecord acdataform Forms!frmCompany!subfrmCompanyExam!Package,,nextrecord
The reference to the subform does not seem to work...shall i continue with this or a
For Each ctl in.....?

 

[pogs]

This is my code: i want to reference subform2:"frmCompanyPackageSub". i think this is not working

For Each ctl In Forms!frmCompany
If ctl.Name = "frmCompanyPackageSub" Then
Set rst = ctl.Form.RecordsetClone
rst.MoveFirst
Do Until rst.EOF
If Con2(36) = True Then
For I = 1 To 35
Con1(I).Value = Con2(I)
Next
End If
rst.MoveNext
'If rst.BOF And rst.EOF Then Exit For
Loop

End If

Next ctl

 

[pogs]

i also tried a docmd method:
DoCmd.GoToRecord acDataForm, Forms!frmCompany!frmCompanySub!frmCompanyPackageSub.Form, , acNext

it has an error: An expression you entered is in the wrong data type for one of the arguments