Open a table in subform?

[ZLHysong]

I have a Form I am using almost as a Hub, And I know I need to use Queries and things, but is there a way I can Set it up to that as I click on items on the Form, it shows the item selected on the same form without opening a new tab in access?

[June7]

Don't understand. If you have the item to click on then it is already on the form. Do you mean you are selecting an item in a combobox, like a customer number? This is an unbound combobox used to select filter criteria and you want the form to go to that customer record on form?

[ZLHysong]

I know... I am horrible at describing these things.

I can't upload the form exactly yet, but I am attaching a Drawing of what I am trying to accomplish.


1 Selects the Subform shown at 2 and 3 selects the table shown at 4.

Is there a way to make this happen?

[June7]

Maybe, still don't quite understand the structure.

Unbound combobox 1 is used as criteria to filter records? Do Tabs 1 to 4 have subforms or are fields on tabs all from same data source and TabControl is just to organize the data?

Combobox 3 selecting records 4 really doesn't make sense. Is 4 a listbox or a subform?