Re: Problem with Filter/Query

From: Ed the Redhead (EdtheRedhead_at_discussions.microsoft.com)
Date: 07/27/04


Date: Mon, 26 Jul 2021 19:59:11 -0700

I tried this and it still does not work. Any other suggestions as to a possible problem?

"Ken Snell" wrote:

> Put the filter in the DoCmd.OpenForm call:
>
> DoCmd.OpenForm "frmAgencies", , "qryAgenciesEditFilterFromSearchScreen"
>
> The third argument of the OpenForm method is the filter that is to be used
> when the form is opened.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Ed the Redhead" <EdtheRedhead@discussions.microsoft.com> wrote in message
> news:3109D0D2-3291-4859-95DB-F40FE509CAB4@microsoft.com...
> > I have the following written in my code:
> >
> > DoCmd.OpenForm "frmAgencies"
> > DoCmd.ApplyFilter "qryAgenciesEditFilterFromSearchScreen"
> >
> > When I run it, it will open the form, but it does not apply the filter.
> When I open the query, it shows exactly the record I want. But when I run
> the code, it opens the form up with all of the records. I did double check
> the name and it is correct. I'm still pretty new to this programming stuff,
> so I'm sure that I'm missing something. Any suggestions?
>
>
>