filtering same subform multiple times? (1 Viewer)

[shrndegruv]

Hey all

simple question: is there any way to apply a different filter to a subform each time it appears on the main form?

I have a subform that would be awesome on multiple tabs of a large form, and Id like to apply a different filter on each tab....

Thanx in advance!

mike

 

[llkhoutx]

Controls on tabs are controls of the form, therefor, you're going to have subform name problems if you put the same subform on each tab.

Merely put the subform on top of the tab control (make sure that there's nothing on the various tabs below it) and appropriately reset the subform filter on the TabChange event. Don't forget to set the subform filter appropriately when the form initially opens.

I used tab controls a long time before I stumbled onto the TabChange event.

 

[shrndegruv]

Thanx for the reply -- The form is tabbed at the top level, there are no controls displayed across all tabs -- maybe that will have to change.

The real problem is that hte filter property applies to the form, not to each subform control. So applying a filter ot a subform in one area affects everywhere else that subform is displayed.

 

[llkhoutx]

Please restate your problem.

 

[shrndegruv]

Restate:

I have one subform I want to use at different places on my main form, applying a different filter in each of the places I display it. It seems this cannot be done.

 

[llkhoutx]

Yes it can be done. It sounds like a very bad design, especially if they are displayed simultaneously. If not, see myfirst post in the topic.