Folks,
I would like to use the tab name in a tabbed form to "filter" the subform on that tab. Having a hard time finding the appropriate method to accomplish this. I want to use a general name like [tabcntl3].[tab.name] so that only one query and subform is required. Thanks

Subforms can be 'filtered' by the links between the subform and main form. Have a hidden control on the main form and use that as the Master link in the subforms MasterLink property. Now you can use code to change the value in the hidden control and the subform will be properly 'filtered'.

Another possibility is to use the value in the hidden control as criteria for your query. Then you do not need to link the subform.

hth,
Jack