Can't open a recordset of a subform (1 Viewer)

[DocNice]

Hey all, I'm trying to open a recordset of a subform.

I've tried:
Set rst = Forms![frmQuickEnter].Recordset
Set rst = Forms![frmMain].Form![frmQuickEnter].Recordset
Set rst = Forms![frmMain].Form![frmQuickEnter].RecordsetClone

All throw errors. Can I open a recordset of a subform, or do I need to do it based on the underlying query.

If I have to do it based on the underlying query, is there code I that would let me add a "Where" statement to that query if I use "Set qd = dbs.QueryDefs!qryQuickEnter"? It's linked to the main form automatically by the primary key, so I don't have any parameters in the query.

Thanks!

 

[RuralGuy]

Have you tried: Set rst = Forms![frmMain]![frmQuickEnter].Form.RecordsetClone?

 

[DocNice]

Thank you! The other language was working for referencing fields, so I assumed I had it right.

Thanks again.

 

[RuralGuy]

You are welcome. Here's a link to bookmark if you don't have it yet:
Refer to Form and Subform properties and controls