recordset.Open Source, ActiveConnection, CursorType, LockType, Options
As discussed in The Significance of Cursor Location, the type of cursor that your application uses will determine which capabilities are available to the resultant Recordset (if any). For a detailed examination of cursor types, see Chapter 8: Understanding Cursors and Locks.
The CursorType argument can accept any of the CursorTypeEnum values.