1

Topic: Access + ms sql the filter after form update (F5) flies

All greetings.
Transferred all tables and requests on MS SQL - received an unpleasant bonus in all forms - at update all filters glork. Thus the tag over a field shows that the filter is active.
Somebody faced a problem? How to solve?

2

Re: Access + ms sql the filter after form update (F5) flies

;
That is somehow to receive current value of the filter and to rewrite a source for the form?
Then still questions:
1) What event of the form works at update of the form without changes?
2) How in that case to be if the user wants to remove the filter?

3

Re: Access + ms sql the filter after form update (F5) flies

Mant1s0, Me. FilterOnLoad tried to use?

4

Re: Access + ms sql the filter after form update (F5) flies

alecko;
Tried. Just at loading the filter works, at update flies.

5

Re: Access + ms sql the filter after form update (F5) flies

;
Parameters for a filtration can just be much. And the table such not one, would be desirable that everywhere worked, therefore the variant with the temporary table not so approaches. I will search still for variants.

6

Re: Access + ms sql the filter after form update (F5) flies

By practical consideration understood that the given problem only with requests.
Solved by import of representation SQL in  as bound table, now all works.
All thanks.