make new rec w/sub datasheet recs based on current rec

[JumpinJimRivers]

Howdy,

I am trying to figure out the best way (actually any way) to copy a record that includes sub data records over to a new record and then go to that new record. I can use an 'Insert SQL' to copy the main record over to a new record and then use the requery method to go to the new record, but I'm hitting a brick wall trying to copy the sub datesheet records over to the new record as well by using the same method, because I need both the Original Record ID and the New Record ID at the same time. This method may be doable still and I'm just not doing it right - I'm not sure yet - but if you have any suggestions I would appreciate it.

Thanks!