Need help with filter on Tab Control (1 Viewer)

Niranjeen · Feb 21, 2019

Hi,
Please can you provide me to slove a filter of records on each tab control.

A form has four tab controls, when each Tab is clicked or selected, a filter should be applied on the recordset from a single table on QtrID(number), and each tab is filtered as 1, 2,3 &4 of the record repersenting each Quarter respectfully.

I may sound very vage in my explantion, but please do not ignore my need. Since, I'm on a deadline for Feb 25, 2019

Thanks in advance.

pbaldy · Feb 21, 2019

In the tab control's change event you can test its value. That will tell you which tab was selected (zero based tab index). From there you can apply your filter as desired.

Niranjeen · Feb 22, 2019

Thanks Baldy,
Might have to make my question tailored to my requirement: Each Tab on the same form should pick a record corresponding to the QtrID. So saying I did use the tab index identifier, but not able to bring in a corresponding recordset.

If my understanding is right, Forms can work with one recordset at one instance, so if using tabs to pull many records to a form will not possible?

Then, would it be better for me to place subform on each tab?

Thanks again.

arnelgp · Feb 22, 2019

1. create 4 queries with criteria on each quarter,eg:

query1:

select * from table1 where qtrID = 1;

2. create a form out of each queries (datasheet).

3. drag each form (as subform) on each tab.

make sure to select the correct tab, before dragging the subform into it.

Niranjeen · Feb 22, 2019

Thank you so much "arnelgp".

It worked well.

Need help with filter on Tab Control (1 Viewer)

Niranjeen

Registered User.

pbaldy

Wino Moderator

Niranjeen

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Niranjeen

Registered User.

Similar threads

Users who are viewing this thread