copying subform

[Bozette]

I'm able to copy the info from a Form to a new record using RecordsetClone and AddNew but can't figure out how to copy the info from the related SUBform. I think part of the problem is because the subform is a contiuous form so I'm missing something there. I'd be glad to post my code and the error I get but thought I'd see if someone had some general suggestions.
Thanks

 

[WildHare]

Since a continuous form can show more than one record, you may have a little trouble with this.

However, if you base your subform on a query, you should be able to "add" records to the child table (represented in the sub) and have them posted to the child table automatically.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm