title: Updateable Form in Visual Basic Access using ADODB connection and command objects
body: <p>I've been tasked with converting over an existing adp project to a accdb project.  I'm almost finished but there's one piece of functionality I can't get to work.  I'm filling a forms RecordSet using a premade stored procedure, similar to the simple example below.</p>
  
  <pre><code>Dim objConn As New ADODB.connection
  Dim objCmd As New ADODB.Command
  
  'Set up connection and command object
  objConn.ConnectionString = "*Connection String Here*"
  objConn.Open
  objCmd.ActiveConnection = objConn
  objCmd.ActiveConnection.CursorLocation = adUseClient
  objCmd.commandText = "StoredProcName"
  objCmd.CommandType = adCmdStoredProc
  
  'Fill the recodset
  Set Me.recordSet = objCmd.Execute
  
  'Close connection
  objConn.Close
  </code></pre>
  
  <p>The problem is that most of the fields within the form are bound, so that the user can change data or changing items within comboboxes.  But when trying to edit the bound controls, I can't do any sort of editting, like the form is locked.  I've also tried setting the forms recordset type property to Dynaset (Inconsistant Updates) and setting the connection object's mode property to acModeReadWrite, but to no avail.  Is there a way to achieve this using ADODB connection and command objects?</p>
  
  <p>Thanks!</p>