Referencing subform recordsets

A

amiga1200

I am trying to access the recordset of a subform on an active form using a
string. Then active form may not always be the same.
When I try the following code, access reports that it cannot find the form

Forms(frmName).Recordset.RecordCount

But when I reference it directly it works

Form_OldGroupsList.Recordset.RecordCount

but if i use this method it does not allow dynamic access

Amiga1200
 
W

Wayne Morgan

Asked and answered in FormsCoding. Please don't post separate messages in
multiple groups. If you want to post in multiple groups, please address all
the groups in a single message so that the replies also go to all of the
groups.
 
M

Marshall Barton

amiga1200 said:
I am trying to access the recordset of a subform on an active form using a
string. Then active form may not always be the same.
When I try the following code, access reports that it cannot find the form

Forms(frmName).Recordset.RecordCount

But when I reference it directly it works

Form_OldGroupsList.Recordset.RecordCount

but if i use this method it does not allow dynamic access
Click to expand...


Please don't post the same question to multiple newsgroups.
I you feel that your question requires it, you might cross
post it to a couple of groups by using both group in the To:
list of a single message.

I responded to this question in the formscoding group.
 
Top