I have this click event on my form. It speaks to a Datasheet Subform
Code:
Private Sub Command260_Click()
 Dim r As DAO.Recordset
 Set r = Form_frmABCD.Form.RecordsetClone
 r.MoveFirst
 Do
    If Nz(r(2)) = "" Then
    Stop
    'Need to move form to this record.  Bookmark??
    Form_frmABCD.RunSelectForm (1)
    DoEvents
    End If
 r.MoveNext
 Loop Until
...