[AccessD] recordset clones

Your Set statement is incorrect.

Change;
Set rs =
Forms![frmInitialMain]![frmInitialSubInstallments].Form![txtInstallID].R
ecordsetClone

To;
Set rs =
Forms![frmInitialMain]![frmInitialSubInstallments].Form.RecordsetClone


John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307.2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeanine Scott
Sent: Tuesday, June 10, 2003 12:11 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] recordset clones


I am attempting to refer to a subform's recordset clone from a different
form (not the parent) the parent and subform are open. I am getting an
error "object does not support this property or method". Is it not
possible to refer to the subform's clone from a different form?

Set rs =
Forms![frmInitialMain]![frmInitialSubInstallments].Form![txtInstallID].R
ecor
dsetClone

If Not rs.EOF Then
    Do Until rs.EOF
        Debug.Print rs("txtOrigTaxDueDate")
    rs.MoveNext
    Loop
End If

Thanks!

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com