P
Penn
Q: Is it possible to use a macro to open a new record that will be linked to
a record in another table?
Detail: I have two tables - Customers & Contacts. The Contacts are linked to
the Customer by the CustomerID. I have a Customer Details form which
contains a Contacts Subform. The Contacts Subform lists (in Datasheet view)
all the Contacts associated with that Customer.
When I double-click on an existing Contact, I can bring up the Contact
Details form to edit the full Contact information.
I would like to be able to use the same macro to open a new record in the
Contact Details form which will have the correct CustomerID. I have
CustomerID fields in the Contacts Subform, the Contact Details form and the
Query that provides records for the Customer Details form.
Penn
a record in another table?
Detail: I have two tables - Customers & Contacts. The Contacts are linked to
the Customer by the CustomerID. I have a Customer Details form which
contains a Contacts Subform. The Contacts Subform lists (in Datasheet view)
all the Contacts associated with that Customer.
When I double-click on an existing Contact, I can bring up the Contact
Details form to edit the full Contact information.
I would like to be able to use the same macro to open a new record in the
Contact Details form which will have the correct CustomerID. I have
CustomerID fields in the Contacts Subform, the Contact Details form and the
Query that provides records for the Customer Details form.
Penn