I have a tabbed form (two tabs). One tab contains a form for adding a new record to TblClients. The other tab contains a more complicated form with an unbound combo box to choose from the list of all clients, and then a couple of subforms displaying various fields (related to the chosen client) from other tables (all connected by ClientID). My intent is to use the tabbed form as an multi-purpose tool to add new clients and/or update info for new or existing clients. For the most part, everything is working as I intend it to. But one thing has me stumped...

I would like to be able to add a new client on the first tab, then go to the second tab, pick the client I just added from the combo, and then add additional data to the related tables via the subforms. I am able to add the client, then pick their name from the combo, but the related fields on the form/subforms don't update. If I choose an existing client, they do. If I close the form and reopen it, it works fine...

So obviously when I open the form, something is happening behind the scenes. I guess what I need to do is add an event that tells the form to do THAT THING everytime I select a client from the unbound combo. Is that on the right track? Can anyone tell me how to accomplish this? As always, THANKS!