Using a tab control as query criteria...

[Ecron]

Hello.

I'm trying to build a query criteria for a tab control with three different tabs. They are all using the same subform in each page. I want to be able to set the criteria for one specific field to the current tab control page that is selected. Does anyone know how to do this? I wasn't able to find it on the forums...

Thanks a bunch!

 

[boblarson]

Ignore the tab as part of the deal as it really doesn't figure into this. What you need in your query is to reference the control that has the data that you want to limit your results by.

The controls on a tab control only appear to be on the tab control, but in essence they are on the form the tab control is on and the reference to them is the same as if you were referencing a control on the main form.

 

[Ecron]

hmmm.

thanks for the response! I didn't know that about tab controls and their appropriate tab controls. That makes things make more sense.

I'll just rebuild my query so it doesn't depend upon the tab form's name.

thanks again!