How can you control a tab

[DogLover2006]

What I am trying to do is, when a you click on each tab it uses a different criteria in the query. for example: the tab is called education and the criteria in the query I want is TxtID Like "pe*" Or Like "su*" Or Like "ta*" Or Like "cu*" Or Like "nh*"

the second tab is called support and the criteria in the query is TxtID Like "ci*" Or Like "br*" Or Like "fn*"

and help would be great, thank you

 

[yummy7]

Can you please send me your code for better understanding.

 

[DogLover2006]

This is what I have:

SELECT DeptName.TxtID, DeptName.DeptName, Dept_Num_Descr.[Agencies/Object], Dept_Num_Descr.[Number#], Dept_Num_Descr.Description, Years.[2005], Years.[2006]
FROM (DeptName INNER JOIN Dept_Num_Descr ON DeptName.TxtID = Dept_Num_Descr.TxtID) INNER JOIN Years ON Dept_Num_Descr.[Number#] = Years.[Number#]
WHERE (((DeptName.TxtID) Like "pe*" Or (DeptName.TxtID) Like "su*" Or (DeptName.TxtID) Like "ta*" Or (DeptName.TxtID) Like "cu*" Or (DeptName.TxtID) Like "nh*") AND (([Forms]![Form1]![TabCtl0])=0)) OR (((DeptName.TxtID) Like "ci*" Or (DeptName.TxtID) Like "br*" Or (DeptName.TxtID) Like "fn*") AND (([Forms]![Form1]![TabCtl0])=1))
ORDER BY DeptName.DeptName, Dept_Num_Descr.[Agencies/Object], Dept_Num_Descr.[Number#];

 

[DogLover2006]

Maybe this will help you better understand what I am try to do.
I have a form with tabs on it and each tab has a subform on it.
When you click on the tab I want the subform which uses a query to populate itself to use the criteria as I described above the code above is from the query I am using.

 

[PHV]

Why not using a different query for each subform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DogLover2006]

The subform is being seven different time and the only difference there is between them is the following criteria:

WHERE (((DeptName.TxtID) Like "pe*" Or (DeptName.TxtID) Like "su*" Or (DeptName.TxtID) Like "ta*" Or (DeptName.TxtID) Like "cu*" Or (DeptName.TxtID) Like "nh*") AND (([Forms]![Form1]![TabCtl0])=0)) OR (((DeptName.TxtID) Like "ci*" Or (DeptName.TxtID) Like "br*" Or (DeptName.TxtID) Like "fn*") AND (([Forms]![Form1]![TabCtl0])=1)) OR (((DeptName.TxtID) Like "es*" Or (DeptName.TxtID) Like "ph*" Or (DeptName.TxtID) Like "pw*") AND (([Forms]![Form1]![TabCtl0])=2)) OR (((DeptName.TxtID) Like "hm*" Or (DeptName.TxtID) Like "ma*") AND (([Forms]![Form1]![TabCtl0])=3)) OR (((DeptName.TxtID) Like "ep*" Or (DeptName.TxtID) Like "pr*4" Or (DeptName.TxtID) Like "cp*") AND (([Forms]![Form1]![TabCtl0])=4)) OR (((DeptName.TxtID) Like "cj*" Or (DeptName.TxtID) Like "em*" Or (DeptName.TxtID) Like "pr*8" Or (DeptName.TxtID) Like "tn*" Or (DeptName.TxtID) Like "ts*") AND (([Forms]![Form1]![TabCtl0])=5)) OR (((DeptName.TxtID) Like "oe*0" Or (DeptName.TxtID) Like "os*" Or (DeptName.TxtID) Like "oa*" Or (DeptName.TxtID) Like "le*" Or (DeptName.TxtID) Like "ca*" Or (DeptName.TxtID) Like "or*" Or (DeptName.TxtID) Like "oe*7" Or (DeptName.TxtID) Like "pc*") AND (([Forms]![Form1]![TabCtl0])=6))

 

[MajP]

Like PHV said, make seven different queries. Each subform is based on its own query.

Or use only one subform and float it on top of the tab control. Then change its recordsource when you tab. I still make seven queries for ease, but only one subform.

Private Sub TabCtl0_Change()
  Select Case TabCtl0
  Case 0
    Me.qryOne_subform.Form.RecordSource = "qryOne"
  Case 1
    Me.qryOne_subform.Form.RecordSource = "qryTwo"
  ...
   case 6
     me.qryOne_subform.form.recordsource = "qrySeven"
  End Select
End Sub

 

[DogLover2006]

MajP,

You said float it on top ot the tab control. How could I do that? I like the sound of that because in all seven tabs it is the same form and if I can get away with just one form that would be great. Thank you for your help.

 

[PHV]

in all seven tabs it is the same form
Have you tried to play with the Filter and FilterOn properties of the Form object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

If you put an object directly on the tab control it becomes part of the page. If you want a control to appear on all tabs, place it on the main form then drag it onto the form. The control actually sits on top of the tab control, but appears as if it is on each page.

Another design option would be to use radio buttons, next to the subform instead of a tab control. You would click a button and the recordsource of the subform would change. Or as PHV said you could just change the filter and not necessarily the recordsource. Basically you could use the select case with an option group

case 1
me.filter = "asdfsdf "
case 2
me.filter = "nkndfke"
...

me.filteron = true

 

[DogLover2006]

MajP,

Thank you for all your help.