Add record and updating

[Rosy]

I have a form that brings in the customer address info. On this form I
would like to put a sub-form that displays the Peachtree ID for this
customer. This works fine. However, when I create a new customer
record, and then in the sub-form a new Peachtree record, the customer
record is not updated with the new Peachtree info. So, when I search
for this customer it doesn't display the Peachtree info because the id
no that is connected to the Peachtree ID I created is not in the
customer table. How do I accomplish this?

[Wayne Morgan]

What field are the two forms linked on (Master/Child)? Are the two forms
based on two different tables/queries? If so, you should be able to create a
query that has the two tables linked on the same field as the forms and do a
search on that query. The Peachtree ID will be available from the table for
the subform.

--
Wayne Morgan
MS Access MVP
"Rosy" <kr****@portlite.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

I have a form that brings in the customer address info. On this form I
would like to put a sub-form that displays the Peachtree ID for this
customer. This works fine. However, when I create a new customer
record, and then in the sub-form a new Peachtree record, the customer
record is not updated with the new Peachtree info. So, when I search
for this customer it doesn't display the Peachtree info because the id
no that is connected to the Peachtree ID I created is not in the
customer table. How do I accomplish this?