How do I append subform with form

[EINSTEIN1221]

I have created a program for our company in Access 2003 that allows users to track inventory, pricing and create purchase orders. I have also created a similar table for tickets. My purchase order table has a primary key assigned that we use for a Purchase order#. The Customer info is contained in this form. The actual product info is contained in a subform which is tied to the form by the Purchase order #. I have structured the Tickets similar. I have created a control button on the Purchase orders form which runs a macro that appends the form information to The Tickets table and this works fine. The problem I am having is in the subform. How can I get the subform information to follow the appended form into the subform on the Tickets form. Their is a field on the Tickets form that shows the Purchase order # from the form it was appended from. Any help would be greatly appreciated. I know the answer is probably right in front of my nose.

[DonRayner]

Hey Einstein1221,

I've read over your post a couple of time and I'm sorry but I really don't know what you are asking. Just pretend that you haven't seen your database and then re-read you post to see if it makes any sense to you. Maybe if you post back with some more information on your database layout we may be able to help.

Welcome to Bytes

[EINSTEIN1221]

More info.

Here is the db structure I am working with:
Form - Purchase Orders---------------Form - Tickets
fields - [PO#] (primary)---------------- Ticket# (primary)
[date]--------------------------------- [date]
[for]-------------------------------------[sold to]
[address]-----------------------------[address]
[city]-----------------------------------[city]
-------------------------------------------[PO#]

Subforms-POtrans-----------------------Tickettrans
[qty]-------------------------------------[qty]
[item]-----------------------------------[item]
[sell]------------------------------------[sell]
[PO#]-----------------------------------[Ticket#}
The Subforms and forms are tied together in a relationship by PO# for purchase orders and Ticket# for Tickets. There are more fields but this gives you an idea. Although we do separate tickets not tied to a PO, I want to be able to put a control button on the PO form that will append the information to the end of the Tickets table.The problem I am having is trying to append the subform into the same ticket as the customer info. Thank you for your response.

[ChipR]

I have created a control button on the Purchase orders form which runs a macro that appends the form information to The Tickets table and this works fine.

What's the code you are using to do this part? Maybe that will reveal what you are doing and what you are trying to do, because it's still not clear (to me at least).