need help w recordset syntax

  • Thread starter Thread starter David via AccessMonster.com
  • Start date Start date
D

David via AccessMonster.com

Hi,

I'm trying to set a variable equal to a subform's recordsetclone, for the
purpose of looping through the subform's recordset. The problem seems to be
in referencing the subform's recordsetclone.

Here's the giant set of commands that are causing the problem:

Dim rst As ADODB.Recordset
Set rst = Forms!frmMailingLists!qfrmMLMembers.Form.RecordsetClone

Whether I use Recordset or RecordsetClone, I get the same error:

Run-time 2455: You entered an expression that has an invalid reference to
the property Form/Report.

I've tried many other variations as well, which cause other errors, so I'm
starting with this.

I don't think that any of the other code in the Sub is related to the
problem, in part because I get the same error when I run this in the
immediate window.

A solution would be greatly appreciated!

Thanks,
David
/dmrst
 
David,

Is qfrmMLMembers the name of the subform control (as opposed to the name
of the form that occupies it)?
Where is this code being called from?
 
Back
Top