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.
Code:
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