Remove filter from sub form only

[MichaelCz]

Hello,

I do Access with my "bible" - Automating MS Access with Macros. Some macro's I convert into VBA when error trapping is needed.

I've come across an interesting problem:

I have a tabbed control on a form with 1 main record source [A], 1 subform which has fields linked to [A] but drawing data from another record source and 1 subform which has no links to anything [C].

When I filter on [C] using pop-up, it works ok, but when I remove the filter using pop-up, it removes the filter from [A] as well - even although [A] is bound to a query.

Any ideas on how to make [C] "independent" of [A] & , other than having a completely separate form?

 

[PHV]

when I remove the filter
How are you doing that ?
I suggest you have a look at the FilterOn property 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