Please help in the duplicate records in subform!

[Jar80]

This is really complicated and i hope i get answers in this!

I use microsoft example which make duplicate data from form and copy it into new record. The code is following:

http://support.microsoft.com/?kbid=208824

I have this code in my database but some field names has changed, nothing else is there.

Database contains also query which contains that same field that are in the microsoft example.

Now this works fine when using Mainform but i have subform in it and it doesn´t work in subform.

Mainform and subform is conneted to each other using ORDERID field.

 

[OnTheFly]

Are you getting an Error? If not, have you tried stepping through and then checking the Append query to make sure it is getting any records when it runs?

That would be where I would start.

Hope this helps.

OnTheFly