28-Jul-2006, 08:02 AM
|
 | Guest | | | | | | | | |
| Re: RecordsetClone theory
"BW" wrote in message
news:OoaLOfHdGHA.4128@TK2MSFTNGP05.phx.gbl
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9347-recordsetclone-theory.html
> I'm fairly new to the VBA side of things. Did you say that any
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9347
> 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
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)
 |