Tab control child form filter

[memogonz]

Hi all, i would like to know if is possible to make a filter on a tab control using multiples sub forms, each one on a diferent page of tab control, for example

Sub Forms:

vendors
category
products

Tab control Pages:

Page1=vendors
page2=category
page3=products

What i try to do is to view all records of vendors sub form listed on tab control page 1(datasheet view), and when i make one click on a spescific vendor of that sub form, automatically filter spescific categories for that vendor previously added, and display those records on tab control page 2 (datasheet view also), and when i click on one of the filtered records on category products (tab control page 2), automatically makes another filter for products on that category and show those records on tab control page 3 in datasheet view also, for example:

Vendors
1
2 by clicking on this record shows on next page
3
4

Categories page filtered records

2.1
2.2
2.3 by clicking on this record shows on next page
2.4
2.5

Products page filtered records

2.3.1
2.3.2
2.3.3
2.3.4
2.3.5

Thanks in advance

 

[ClydeData]

I use something simmilar all the time
On page one I have a customer selection/search form you ca get the code for this from thread

thread702-641913

In The form header I have a hidden text box called ShowID
with the control sorce set to
=[CustomerSelect].[Form]![ID]

The link child and link master properties are then set to
ID and ShowID for an orders list subform.

I can email you a copy if you wish

Best of luck

Jimmy

 

[memogonz]

Thanks Jimmy, and i really apreciate if you can send me that copy by e-mail to see it.

thanks in advance.