Hi Dirk,
Understanding WHY makes it easier for me to remember the programming code.
You helped me on that. Thank you very much !

Hi BW,
Dirk answered my question but I leave it up to you to conclude the thread,
in case you need to go on on this.

Greetings
--
eric


"Dirk Goldgar" wrote:

> "BW" wrote in message
> news:OoaLOfHdGHA.4128@TK2MSFTNGP05.phx.gbl
> > I'm fairly new to the VBA side of things. Did you say that any
> > changes made to the recordset clone are then saved to the original
> > forms recordset automatically?
>
> I'm not sure what you mean. Both the form's recordset and the clone of
> that recordset are linked to the same table or tables. Changes to the
> records and fields in one will be reflected in the other, so data
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9347-recordsetclone-theory.html
> changes made to the recordsetclone will be apparent on the form.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9347
> However, the form's recordset is linked to the form, so the current
> record in the recordset is the current record on the form, and
> navigation in the recordset also navigates the form. But the
> recordsetclone is not linked directly to the form, so you can navigate
> in the recordsetclone without affecting the form.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>