I have an one to many relation between Franchisee info table and stores info table. The relations between franchisee and store is tax id. I have a form that contains the Franchisee info and in the sub form is the store info.
When the form opens it is loaded with the first record. I have a combo box to search and load the form and sub form. I need to create a combo box based on the info in the sub form and load the main form based on that entry in the combo box.

I am able to build my combo box but not able to load the form and sub form. Can this be done...

Thank you, Congamond