Hi arnelgp,
I assume it's disconnected because this line of code appears to successfully disconnect it:
Set MyDisconnectedRS.ActiveConnection = Nothing
If I don't run this line, editing the recordset (via the subform) edits the underlying table, so the disconnection seems to work. Also, all...