Filters in subforms

[Lars Munch]

Hi

When I have a form containing a sub form, the data of the
main form and the sub form resp. is selected by two
queries. I have one filter for the main form and another
filter for the sub form. The buttons to edit and apply
the filter for the sub form are located within the sub
form, and the buttons to edit and apply the filter for
the main form are located outside the sub form. When I
press the button to apply the filter for the sub form,
Access prompts me for the values in the query defining
the data of the sub form, as if Access at this point can
only read the query for the main form. If I right-click
any of the buttons and select "disregard filter", Access
disregards the filters both for the main form and the sub
form.

In order to use the same filters for reports, I have
saved them as queries. Therefore it has been necessary
to modify the VB code for the buttons compared to the
code generated automatically by the button wizard. My
code is functioning OK for forms without sub forms and
for the main form as well, but not for the sub form. It
is also functioning for reports without sub reports.

Isn't Access able to handle filters in sub forms properly?

Regards
Lars

 

[Wayne Morgan]

There are some bugs when filtering main and sub forms. See if the
information here helps.

http://members.iinet.net.au/~allenbrowne/bug-02.html

 

[Lars Munch]

This confirms to me, that it is correct, when I observe
some problems, but it doesn't actually solve my problem.
On the contrary it tells me, that the problem may be
difficult to solve. Does anyone know, if Microsoft is
working with this problem, and if (or when) we can expect
a solution?

Lars

 

[Allen Browne]

Lars, all I can say is that I am working on trying to get Microsoft to solve
this and other problems that affect us all, but don't hold your breath. It
may add a little weight if you have the time to let them know this has
bitten you also.