Open a given form using filters applied into an another mask.

[eviscerator]

This may sound simple but to me is not.

Two mask are given in this database.

Mask1 recordsource is a query based on table1.
mask2 recordsource is table1

On mask1 I set different filters, then an event routine is triggered whenever i press a button with the following VB code:

If Me.Filter = "" Then
        DoCmd.OpenForm "mask2"
    Else
        DoCmd.OpenForm "mask2", acNormal, , Me.Filter

And here the problem comes as it doesn't want to work.

If I change mask1 to the same recordsource as mask2 it works and mask1 filters are applied to mask2 correctly.

Still, I cannot change mask1 recordsource as I need that mask to display only a few fields, there.

Could there be any solution?

 

[eviscerator]

bumping a bit the thread

 

[eviscerator]

Another bump :\