Filter by Selection in subform

[Ed]

Hi All: Using Access xp. I have a form that opens filtered to a chosen
customer. this form has a subform that has detail items related to this
customer. all works fine but when in the subform i can right click and
select filter by selection in any field and it only shows detail items as
selected (fine) but when i right click and hit remove filter sort the main
form reverts to the first customer in its recordset when i only want to
remove filter for the detail items in sub form retaining the filter for the
main form as originally opened. Any help?
Thanks, Ed

 

[Allen Browne]

The problem you describe is a known bug that has been present in Access for
9 years.

I cannot get Microsoft it fix it. They just keep releasing new versions
without fixing the bugs, so more and more people end up being hurt by them.
Please consider telling Microsoft what hou think about this. If enough
people do, who knows? They may even have to start fixing them.

There are several other bugs relating to filters. Four of them are outlined
in this article:
Incorrect filtering of forms and reports
at:
http://members.iinet.net.au/~allenbrowne/bug-02.html

In my view, leaving the same bugs unfixed through 5 versions (95, 97, 2000,
2002, 2003) is just ridiculous.

 

[Ed]

Thanks, Great info and thanks for the bonus web site you have.
Ed

 

[Dr. Know]

Allen Browne said:

The problem you describe is a known bug that has been present in Access for
9 years.

I cannot get Microsoft it fix it. They just keep releasing new versions
without fixing the bugs, so more and more people end up being hurt by them.
Please consider telling Microsoft what hou think about this. If enough
people do, who knows? They may even have to start fixing them.

There are several other bugs relating to filters. Four of them are outlined
in this article:
Incorrect filtering of forms and reports
at:
http://members.iinet.net.au/~allenbrowne/bug-02.html

In my view, leaving the same bugs unfixed through 5 versions (95, 97, 2000,
2002, 2003) is just ridiculous.

Good God!

I just spend 4 hours trying to figure out this exact bug!
Nothing mentioned in the MSDN disks or Access Help.

The applyfilter and onfilter events also don't behave properly across
forms and subforms - as well as the filteron and filter properties.

Kinda makes filters USELESS! (To me, anyway.)

Thanks for the info. It would have taken me many hours to properly
document this "feature".



Dr. Know

 

[Dr. Know]

Allen Browne said:

The problem you describe is a known bug that has been present in Access for
9 years.

I cannot get Microsoft it fix it. They just keep releasing new versions
without fixing the bugs, so more and more people end up being hurt by them.
Please consider telling Microsoft what hou think about this. If enough
people do, who knows? They may even have to start fixing them.

There are several other bugs relating to filters. Four of them are outlined
in this article:
Incorrect filtering of forms and reports
at:
http://members.iinet.net.au/~allenbrowne/bug-02.html

In my view, leaving the same bugs unfixed through 5 versions (95, 97, 2000,
2002, 2003) is just ridiculous.

I just spend 4 hours trying to figure out this exact bug!
Nothing mentioned in the MSDN disks or Access Help.

The applyfilter and onfilter events also don't behave properly across
forms and subforms - as well as the filteron and filter properties.

Kinda makes filters USELESS! (To me, anyway.)

Thanks for the info. It would have taken me many hours to properly
document this "feature".


Dr. Know