Error 3420 "Object invalid or no longer set"

[DaveBo]

In Access, I have a form with a subdatasheet on it that's loaded from a local table.

I select a row in that sheet and click a button to fire-up a second form, everything's wonderful.

When I close the second form, returning to the original, and then try to access a record on the subdatasheet again, e.g.

CurrObjName = Me.Database_Compare_Results_Subform.Form.Recordset(1)

I get the above error.

Any ideas? I've tried requery and refresh and cloning the recordset ... no joy.

Thanks, DaveBo

[DaveBo]

Well, my solution for now is:
since I can't get directly at the data in the subdatasheet,
I'm getting its .RecordSource .Filter and .OrderBy properties,
building an SQL query from that, and loading a temp recordset in code.
Then I just line up the current record with the selected row on screen using a rst.Move x.

Works!