Dirk, You response clarified my question. I was misunderstanding
"RecordsetClone" to mean a static copy of the forms data.

Thanks
Brent

"Dirk Goldgar" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9347-recordsetclone-theory.html
news:%23Bh0SqLdGHA.1436@TK2MSFTNGP05.phx.gbl...
> "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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9347
> records and fields in one will be reflected in the other, so data
> changes made to the recordsetclone will be apparent on the form.
> 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)
>
>