Capturing the recordset of a subform

[tylerg11]

When my main form loads, I run the following code (see fragment of code below). The purpose is to "capture" the recordset of the subform and set it to a DAO recordset.

Set rstRecord = Me.SubformName.Form.RecordsetClone

However, sometimes it bugs out with the following error. It works most of the time, but I'm not sure what I'm doing wrong here.

Help would be appreciated! Thanks.

[June7]

I don't know why this error triggers. Nothing seems wrong about that one line of code, assuming you have a real subform name in place of SubformName.

Did you explicitely declare the rstRecord variable as a DAO recordset object?

Have you step debugged? You don't know what is different about the situation that triggers the error?

Is the subform container control named different from the object it holds?

It is possible to manipulate a form's recordsetclone without a variable object. Depends what you are doing with the recordset.