Re: Problem with Filter/Query

From: Ken Snell (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 07/27/04


Date: Tue, 27 Jul 2021 09:15:07 -0400

This thread is being abandoned in favor of a duplicate thread in another
newsgroup.

-- 
        Ken Snell
<MS ACCESS MVP>
"Ken Snell" <kthsneisllis9@ncoomcastt.renaetl> wrote in message
news:%23tuerq4cEHA.1184@TK2MSFTNGP11.phx.gbl...
> What is the SQL statement of the filtering query?
>
> -- 
>
>         Ken Snell
> <MS ACCESS MVP>
>
> "Ed the Redhead" <EdtheRedhead@discussions.microsoft.com> wrote in message
> news:3FB20FB6-5F88-4044-82AF-F64209790611@microsoft.com...
> > 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?
> > >
> > >
> > >
>
>