Unanswered: Filtering Combo box from another subform
I have a main form(Client), on my main form I have several tabs. On one of my tabs is the client information and within that tab I have a subform that provides who is all in the household(this information is in datasheet view and typed in such as First & Last name). Then on one of the other tabs I have Life skills, which has a combo box. In this combo box I would like for it to filter the only the names that were entered into the first tab.
So say on the datasheet names entered are
On my Life Skills tab, I would like the dropdown to show only those names entered.
I am able to have it show those names, however, only on the first instance of the form. If I open the form, look up an existing client, go to the life skills tab, it will filter. However, if I change the client it does not refresh. I put the criteria in the query and maybe I need to write code so that it will refresh. But I'm not sure. Any ideas/help appreciated!