error setting RecordSource to Form

Question

I have a form that has a button that opens another form.  In the form that is being called to open.  I try to set the Recordset and I get an error msg.

In the "On Open" of the form that is being called to open, I have this line below.  It is being applied to a subform in that form.

        Forms![Frm_EmailViewerUpdate].[frm_EmailViewerUpdate subform].Form.RecordSource = ""

        Call SQL_PassThrough(strConnection, strSQLGUID, strLinkedTableName)

        Forms![Frm_EmailViewerUpdate].[frm_EmailViewerUpdate subform].Form.RecordSource = strLinkedTableName

Error msg I get is :

Run-time error '2467':

The expression you entered refers to an object that is closed or doesn't exist.

I tried putting my code in the "on load" and I get the same error msg.

Answer 1

I moved the following lines to the "on Corrent" and it is fine now.

Forms![Frm_EmailViewerUpdate].[frm_EmailViewerUpdate subform].Form.RecordSource = ""

Forms![Frm_EmailViewerUpdate].[frm_EmailViewerUpdate subform].Form.RecordSource = strLinkedTableName

Answer 2

Thanks for the update.