Search for all Tabs

[RawToast]

Hello,


I have one spreadsheet with lots of client information on it - too much to meaningfully display on one form. I have broken the information up into different forms representing different categories (for example: "General" "Purchases" "Mailing"). I then assembled those forms into tabs within a single form, "MainControl", first using the "Navigation Form" feature, and then instead switching to the subform tab control feature.

What I would like to have is a search bar at the top of my MainControl parent form, above the tabs, where I could search for a client ID number and all of the subforms in the tabs would present information on that client. In previous Access projects, I have relied on copy pasted single-form search buttons that do not work in this application. I have tried in vain to make adjustments to these buttons (I have some programming know-how, but VBA is lost on me), but I have now given up and am hoping someone here might be able to help.

Thank you very much!
-Theo

[ranman256]

enter the ID in the textbox
then filter the MAIN form

me.filter = "[id] = " & txtID
me.filterON = true

the sub form will fill with that client data. You have a sub form right?
the subform is controled by the TABS.
case tab.value = "Purchases"
sub.sourceObject = "frmPurchase-sub"
case tab.value = "Mailing"
sub.sourceObject = "frmMail-sub"