Append Records from a subform to a new record

[Billp]

Hi,

I create a new record.
I can get the information onto the main form duplicated.
How do I copy the subform to the new records subform. the subform is linked
to the main form via "CustomerID" a unique number. The subfrom has a record
idenifier and also the CustomerID as a number - one to many relationship.
It is not quite like Alen Brownes new record duplication as the new record
is open already.
On a new record the user can enter a new customer name. They can then select
from a combo box a similar record (say the old customer name as the company
has changed name) and "On update" the main form duplicates that record and
fields are populated. In the subform is contact details. It is these details
that are needed to be copied across to the new subform.
I can figure it would need to be via sql and an append query - what is the
link part from the old record to the new record so that the records copy
accross?
Thanks in advance

 

[Graham Mandeno]

Hi Bill

I have already answered this question in
microsoft.public.access.modulesdaovba.

Please do not multipost messages to newsgroups. If it is appropriate (as in
this situation) then please crosspost instead.

For an explanation of the difference, see here:
http://www.blakjak.demon.co.uk/mul_crss.htm