How to copy a recordset!?!?!

[Tlm]

Hello All,

I have a form (FrmA) with a subform (SubFrmB) embedded in it. SubFrmB also
has a subform embedded in it (SubFrmC) The form's recordsource is based on a
table (TblA). SubFrmB's recordsource is also based on a table (TblB).
SubFrmC's recordsource is also based on a table (TblC).



There is a one-to-many relationship between TblA (one) and TblB (many).
There is a also a one-to-many relationship between TblB (one) and
TblC(many). The forms are similarly linked.



I want to be able to copy the recordset in SubFrmB - along with its many
records in SubFrmC - so I can then insert that recordset as a new record in
FrmA.



I considered using the RecordsetClone function for this. But since the
RecordsetClone property setting makes a copy of the underlying table
specified by the form's RecordSource property, that won't work for me since
there are three tables in play here.



Any and all suggestions on how I could possibly accomplish this would be
GREATLY appreciated!



Thanks!!!



Tom

 

[Van T. Dinh]

(answered in a later post.)

Please do not multi-post the same question.

See <http://www.mvps.org/access/netiquette.htm>

HTH
Van T. Dinh
MVP (Access)