> See:
> Duplicate the record in form and subform
> at:
>
http://allenbrowne.com/ser-57.html>
> The article suggests duplicating the main record with AddNew on the main
> form's RecordsetClone (which gives you the new primary key value), and then
> executing an Append query statement to duplicate the related records (which
> gives you precise control over which fields are duplicated.) If you have
> several related tables (populating several subforms), you will execute
> several Append query statements.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users -
http://allenbrowne.com/tips.html> Reply to group, rather than allenbrowne at mvps dot org.
>
> "alathwell" <alathwell[ at ]discussions.microsoft.com> wrote in message
> news:B3B666BB-0D58-45B5-B62A-1DEA3544AAD8[ at ]microsoft.com...
> >I have a databse that genrates quotations and consists of a mian form and
> > several tabbed subforms. The user base needs to be able to copy the
> > quotation. I currently do this in what I consider not particularly smart
> > way.
> > In VB I basically run the copy command for the main forms data then using
> > a
> > querydef recordset to loop through the other related records from the
> > related
> > tables. In the loop I create a new repord and copy every field into the
> > new
> > record. It does work but I am not happy with this approach. I would like
> > an
> > more articlulate way of doing this. What the user wants is to view the
> > copied
> > version immedioately the copy is completed.
> >
> > Any suggestions would be appreciated.
> >
> > Regards
> >
> > alalthwell
>
>