I have a parent form that displays customers by their Tax ID's. However, one tax ID can have several names attached to it. As I change the combo box Tax IS, the listbox with all the names changes to display those that are associated with this Tax id. This part is fine. However, there is a sub-form ont his main form that, as the NAME in the list box changes, I want the subform to display teh details for that name. So, the subform is not really associated with teh TaxID, is is associated with the names (with their Key ID) in the LIst box. How can I update the subform based on the NAME key id, not the main form's Tax ID?
ASKER CERTIFIED SOLUTION
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Excellent. Much simpler than I thought it would be.