title: Save record changes - Access ado form
body: <p>Help please!</p>
  
  <p>I've created a database for logging service calls, based on one of Microsoft's templates (Very loosely based now!)</p>
  
  <p>I have a "Case Details" form, which is opened from a case list split form.  Originally, this was opening the form with a filter - which I assume means that it is actually loading the whole recordset?</p>
  
  <p>As I assume (hopefully correctly) that this will be quite inefficient as the database grows, I decided to change the form to open and ADO recordset, using a SQL statement, only selecting the record I want.  </p>
  
  <p>The code for this is as follows, and the form opens with the correct record, and I can update the fields.</p>
  
  <pre><code>Private Sub Form_Load()
  On Error GoTo Form_Load_Err
  
  Dim cn As ADODB.Connection
  Dim rs As ADODB.Recordset
  
  If (IsNull(TempVars!currentid)) Then
  
  Me.DataEntry = True
  
  Else
        'Use the ADO connection that Access uses
    Set cn = CurrentProject.Connection
    'Create an instance of the ADO Recordset class,
    'and set its properties
    Set rs = New ADODB.Recordset
    With rs
       Set .ActiveConnection = cn
       .Source = "SELECT * FROM Cases WHERE ID = " &amp; TempVars!currentid &amp; ";"
       .LockType = adLockOptimistic
       .CursorLocation = adUseClient
       .CursorType = adOpenStatic
       .Open
    End With
    'Set the form's Recordset property to the ADO recordset
    Set Me.Recordset = rs
    Set rs = Nothing
    Set cn = Nothing
  
  End If
  
   Call IntializeCollections
  
  
  Select Case (Me.Status)
     Case 7, 8
       Call EnableControls(mcolgrpAllFields, False)
  End Select
  
  
  Form_Load_Exit:
      Exit Sub
  
  Form_Load_Err:
      MsgBox Error$
      Resume Form_Load_Exit
  
  End Sub
  </code></pre>
  
  <p>However, here is the problem.  What the blinking heck do I do to save my changes?  I've done some googling, and looked at <a href="https://stackoverflow.com/questions/5641760/ms-access-form-bound-to-ado-disconnected-recordset">MS Access Form Bound to ADO Disconnected Recordset</a>  but I'm still absolutely stumped.</p>
  
  <p>Is there as simple "save the updates" command? or do I have to iterate through each field, check for changes, then save those changes?</p>
  
  <p>Can someone please point me in the right direction?</p>
  
  <p>Thanks in advance</p>