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.
Warm regards,
Penn White
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.
Warm regards,
Penn White