Understanding Form Recordset

[Middlemarch]

Private Sub Form_Current()
    Dim zz  As DAO.Recordset
    Set zz = Me.Form.RecordsetClone
    Debug.Print zz.Name
    Debug.Print Me.RecordSource
    MsgBox zz!Code & " " & Me!Code

My question is why is zz!Code different to Me!Code ?



Both zz.name and me.Recordsource are the same. The name of the Forms query.
me!Code is the current value of Code, whereas zz.code is the value of Code in the query's first record.

Shouldn't zz be the current record ?

[June7]

Me!Code is referring to field in form's dataset.

zz!Code is referring to field in RecordsetClone object.

No, zz will not open with focus on same record that has focus on form. Code can loop through recordset without affecting the form.

[Middlemarch]

Righteeoo, thanks. It was just in another case Recordsetclone *is* the Current Record when Form is a subForm.

Me![subTracks].Form.RecordsetClone

[Welshgasman]

Do not do what another member does here all the time.
Process a recordset, yet still refer to the form controls and wonder why the values are the same all the time.

[June7]

Righteeoo, thanks. It was just in another case Recordsetclone *is* the Current Record when Form is a subForm.

Me![subTracks].Form.RecordsetClone

I tested this and recordset cursor is on first record regardless of which record in subform has focus.