Add record and updating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rosy - 21 Feb 2005 19:00 GMT

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?

Reply to this Message

Wayne Morgan - 22 Feb 2005 11:04 GMT

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.

Signature

Wayne Morgan
MS Access MVP

>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
[quoted text clipped - 4 lines]
> no that is connected to the Peachtree ID I created is not in the
> customer table. How do I accomplish this?

Reply to this Message