Instead of adOpenStatic, use the adOpenDynamic when you want to open your recordset. It will open a dynamic recordset.
One more thing, set the CursorLocation property in your recordset to adUseClient.