Got a trouble with forms (remove filter/sorting)

[steven_s]

Hello!
I've created 2 similar forms with 1 subform in each of them:
1st - ZAMOWIENIA - with orders
2nd - PRZETARGI - with biddings



Hyperlink to the file: <link deleted>

The PRZETARGI form is completely the same as ZAMOWIENIA (but data comes from different tables).

The problem is that ZAMOWIENIA form works fine, i am able to filter data by ODSWIEZ (Refresh) button but PRZETARGI does not (grey field ;/). To see the data on the subform in PRZETARGI form i am obliged to click on ODSWIEZ (Refresh) using right mouse button and then choose 'remove filter/sorting' option.

May somebody help with that issue? I can't handle it :/

Thx beforehand! Regards!

[llkhoutx]

Me.filteron = false 'keeps form from using the filter

I didn't look at your zip file.

[steven_s]

Me.filter = false 'keeps form from using the filter

I didn't look at your zip file.

Thanks for your interest but it didn' help :/ Still do not know the issue but I found out that removing path from RecordSource and setting it to blank resolved my problem.

Any quess why? Do not have any clue :/

Steven

[llkhoutx]

Note my corrected posting.

me.filteron=false 

[steven_s]

Note my corrected posting.

me.filteron=false 

Well it did not help :/ I've received a tip to remove path from RecordSource and it works. Still do not know why, but it's a solution indeed.

Thanks dude!