How to remove a filter

[Matthew]

Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form. Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1 out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[Guest]

Hi Matthew,

What are you trying to do? Access is working just fine.

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to those
that conform to the link criteria - presumably just one record in your case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access uses
these properties to synchronize sub forms -a fact I don't know for certain.

Regards,

Rod

Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form. Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1 out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[Matthew]

Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew

Hi Matthew,

What are you trying to do? Access is working just fine.

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to record
1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[J. Goddard]

Hi -

When you open a form, the linkcriteria is essentially a where clause,
but without the where, that tells the form which records to display.

In your case, you are opening form2 with a linkcriteria that looks like
only specifies one record.

Even if combo box 2 shows many choices, it not do what you think it
should because it searches the recordset underlying form2, and that
recordset may only have one record.

If form2 is supposed to show record(s) only for the person (contactID)
selected in form1, then your code to open form2 is fine, and you don't
need combo box 2 at all - it does the same thing.

If form2 only shows one record, there is only one record to show.

John

Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew

Hi Matthew,

What are you trying to do? Access is working just fine.

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

:

Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to record
1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[Matthew]

Hi,

Thanks for your help.

Initially, Form2 is behaving correctly. I select a record from Form1, and
Form2 opens, showing me that record.

My problem is, I don't want to have to close Form2 and go back to Form1 in
order to select another record. I want to be able to use the combo box on
Form2. I want Form1 to remain closed. But, since I've opened Form2 with
link criteria, I cannot use combobox2.

So I assume that I need to tell it to forget its criteria. Do I need to
somehow reset its recordset? Because I've tried turning off filters, that
doesn't work. If I go to the menu and remove the filter, that works - it
takes me to the first record in the query. I can accomplish this via code,
on a button. But the code does not work when I put it in the BeforeUpdate
event of the combobox.

Thanks again.

Matthew

Hi -

When you open a form, the linkcriteria is essentially a where clause, but
without the where, that tells the form which records to display.

In your case, you are opening form2 with a linkcriteria that looks like
only specifies one record.

Even if combo box 2 shows many choices, it not do what you think it should
because it searches the recordset underlying form2, and that recordset may
only have one record.

If form2 is supposed to show record(s) only for the person (contactID)
selected in form1, then your code to open form2 is fine, and you don't
need combo box 2 at all - it does the same thing.

If form2 only shows one record, there is only one record to show.

John

Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew

Hi Matthew,

What are you trying to do? Access is working just fine.


stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

:


Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this
Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to
record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[J. Goddard]

Is your data such that form2 could be a subform of form1, linked by
ContactID? From your description, it seems that both forms and both
combo boxes use contactID.

John

Hi,

Thanks for your help.

Initially, Form2 is behaving correctly. I select a record from Form1, and
Form2 opens, showing me that record.

My problem is, I don't want to have to close Form2 and go back to Form1 in
order to select another record. I want to be able to use the combo box on
Form2. I want Form1 to remain closed. But, since I've opened Form2 with
link criteria, I cannot use combobox2.

So I assume that I need to tell it to forget its criteria. Do I need to
somehow reset its recordset? Because I've tried turning off filters, that
doesn't work. If I go to the menu and remove the filter, that works - it
takes me to the first record in the query. I can accomplish this via code,
on a button. But the code does not work when I put it in the BeforeUpdate
event of the combobox.

Thanks again.

Matthew

Hi -

When you open a form, the linkcriteria is essentially a where clause, but
without the where, that tells the form which records to display.

In your case, you are opening form2 with a linkcriteria that looks like
only specifies one record.

Even if combo box 2 shows many choices, it not do what you think it should
because it searches the recordset underlying form2, and that recordset may
only have one record.

If form2 is supposed to show record(s) only for the person (contactID)
selected in form1, then your code to open form2 is fine, and you don't
need combo box 2 at all - it does the same thing.

If form2 only shows one record, there is only one record to show.

John

Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew




Hi Matthew,

What are you trying to do? Access is working just fine.



stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

:



Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this
Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to
record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[Matthew]

My intention is to have Form1 as the general switchboard. From it, one can
choose to view either a Contact (Form2), an Organization (Form3) or a
Category (Form4).

So they select a contact (or an organization or a category), and that takes
them to their Form2, (or 3 or 4). Once they're there, they might want to
view other contacts, so I want to be able to re-establish that the recordset
should be all of qryContacts, not just qryContacts where ContactID = a
specific ID.

Thanks!

Matthew

Is your data such that form2 could be a subform of form1, linked by
ContactID? From your description, it seems that both forms and both combo
boxes use contactID.

John

Hi,

Thanks for your help.

Initially, Form2 is behaving correctly. I select a record from Form1,
and Form2 opens, showing me that record.

My problem is, I don't want to have to close Form2 and go back to Form1
in order to select another record. I want to be able to use the combo
box on Form2. I want Form1 to remain closed. But, since I've opened
Form2 with link criteria, I cannot use combobox2.

So I assume that I need to tell it to forget its criteria. Do I need to
somehow reset its recordset? Because I've tried turning off filters,
that doesn't work. If I go to the menu and remove the filter, that
works - it takes me to the first record in the query. I can accomplish
this via code, on a button. But the code does not work when I put it in
the BeforeUpdate event of the combobox.

Thanks again.

Matthew

Hi -

When you open a form, the linkcriteria is essentially a where clause, but
without the where, that tells the form which records to display.

In your case, you are opening form2 with a linkcriteria that looks like
only specifies one record.

Even if combo box 2 shows many choices, it not do what you think it
should because it searches the recordset underlying form2, and that
recordset may only have one record.

If form2 is supposed to show record(s) only for the person (contactID)
selected in form1, then your code to open form2 is fine, and you don't
need combo box 2 at all - it does the same thing.

If form2 only shows one record, there is only one record to show.

John

Matthew wrote:

Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew




Hi Matthew,

What are you trying to do? Access is working just fine.



stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to
those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

:



Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this
Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to
record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew

 

[J. Goddard]

Hi Matthew -

Let's give it another try!


Actually, the solution is so simple -

All you need to do is change the form's filter in the After Update event
of combo box2, and requery the form.


Combobox2 should not have to be requeried, if it is getting its values
from a table.

You can initially open form2 etc using the link criteria to display the
first set of records.

Now that I look at it though, since the main form combo box and the
secondary forms' combo boxes do the same thing, (I think) selecting
contacts, would it not be simpler just to use the main form as a
switchboard, and do all the Contact Selection in the secondary forms,
i.e. do away with the main form combo box?

Just a thought

John

My intention is to have Form1 as the general switchboard. From it, one can
choose to view either a Contact (Form2), an Organization (Form3) or a
Category (Form4).

So they select a contact (or an organization or a category), and that takes
them to their Form2, (or 3 or 4). Once they're there, they might want to
view other contacts, so I want to be able to re-establish that the recordset
should be all of qryContacts, not just qryContacts where ContactID = a
specific ID.

Thanks!

Matthew

Is your data such that form2 could be a subform of form1, linked by
ContactID? From your description, it seems that both forms and both combo
boxes use contactID.

John


Matthew wrote:

Hi,

Thanks for your help.

Initially, Form2 is behaving correctly. I select a record from Form1,
and Form2 opens, showing me that record.

My problem is, I don't want to have to close Form2 and go back to Form1
in order to select another record. I want to be able to use the combo
box on Form2. I want Form1 to remain closed. But, since I've opened
Form2 with link criteria, I cannot use combobox2.

So I assume that I need to tell it to forget its criteria. Do I need to
somehow reset its recordset? Because I've tried turning off filters,
that doesn't work. If I go to the menu and remove the filter, that
works - it takes me to the first record in the query. I can accomplish
this via code, on a button. But the code does not work when I put it in
the BeforeUpdate event of the combobox.

Thanks again.

Matthew




Hi -

When you open a form, the linkcriteria is essentially a where clause, but
without the where, that tells the form which records to display.

In your case, you are opening form2 with a linkcriteria that looks like
only specifies one record.

Even if combo box 2 shows many choices, it not do what you think it
should because it searches the recordset underlying form2, and that
recordset may only have one record.

If form2 is supposed to show record(s) only for the person (contactID)
selected in form1, then your code to open form2 is fine, and you don't
need combo box 2 at all - it does the same thing.

If form2 only shows one record, there is only one record to show.

John

Matthew wrote:


Hi Rod,

Thanks for your reply.

These are two distinct forms. Form2 is not a subform of Form1.

I've tried me.filteron = false or me.filter = ""; neither work.

If I create another button that removes the filter, click on that first,
then it works.

Maybe I need to be looking at another event, other than BeforeUpdate?

Thanks again!

Matthew





Hi Matthew,

What are you trying to do? Access is working just fine.




stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

This code is restricting the records included in the second form to
those
that conform to the link criteria - presumably just one record in your
case.
Isn't this what you want?

However if you want to remove a filter then either

me.filteron = false or me.filter = "" should work provided that Access
uses
these properties to synchronize sub forms -a fact I don't know for
certain.

Regards,

Rod

:




Hello,

I'm having a hard time removing a filter.

Form 1 has a combo box, to select a person. AfterUpdate of this
Combo1:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"

stLinkCriteria = "[ContactID]=" & Me![ContactID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Form2 also has a combo box which I use to find records on that form.
Combo2
AfterUpdate:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Me![Combo2])
Me.Bookmark = rs.Bookmark

If I were to open Form2 from scratch, it shows me that I'm on record 1
out
of 3,000, and Combo2 works just fine.

However, if I use Form1 Combo1 to open Form2, it opens filtered to
record 1
of 1. Now Combo2 won't work.

I've tried inserting various code in Combo2 BeforeUpdate, including

Me.Combo2 = Null
or
Me.Filter = ""
or
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

These don't work.

What does work is if I create a button on the form, with the following
'remove filter' code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70

But having to have my users press a Remove Filter button is way too
klunky.
There's got to be a way to make this work. Any suggestions are most
appreciated!!

Thanks!

Matthew