Filter by form not working properly

[Beady]

Hi,

I'm working in Access 97 and I've got a form that I want to use to create filters with.

There are a couple of things that I'm not clear about and I'd appreciate any suggestions that you can make:

1. The form seems to remember the last filter, so when I click on the Filter by form button it shows the last filter by default. I've included the following in the click event:
RunCommand (acCmdRemoveFilterSort)
Me.FilterOn = False
RunCommand (acCmdFilterByForm)
Surely either of the first two statements should remove the filter, shouldn't they? and if not then what are they for?

2. I can't get the 'OR' tabs to show at the bottom of the filter by form screen unless I apply the filter once and then click on the filter by form button again. Is there any way of forcing these tabs to appear?

Thanks for any help/advice you can offer.

Regards,
Bernard D

 

[MStef]

Hello Bernard!

When you click on FILTER BY FORM icon, you can see
CLEAR GRID icon, click on this ikon to clear last filter.

 

[Beady]

Thanks,

yes I see that. Ideally I'd like to have that as a button on the form. So I included a button that has these two statements:
RunCommand (acCmdRemoveFilterSort)
Me.FilterOn = False

This does in fact clear the filter from the record (I can then see all records), however when I click on the Filter by Form button again, it still shows the previously chosen filter, that is the criteria I previously had for the filter. It's that, that I want to remove.

PLUS even more irritatingly,

I can't get the 'OR' tabs to show at the bottom of the filter by form screen unless I apply the filter once and then click on the filter by form button again. Is there any way of forcing these tabs to appear?