Tab Control (Filter)

[Gaupo]

I have a form with three tabs all pulling from one query off the main form. I have a combo on each of the tabs that list a different type of publication based on filtering. The problem is on each of the tabs I can see all data from the table. How can I filter out data other than what is requested using the combo box (dropdown)

This is in access 2003

 

[jimlee]

are you trying to filter the form based on what the user selects in the combo boxes? (maybe an obvious question, but just checking first)

jimlad

"There is more to life than simply increasing its speed."
-Mahatma Gandhi

 

[Gaupo]

Correct! And it will pull the correct info on each of the TABS but it also shows data for all by scrolling.