Re: Problem with Filter/Query

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

  • Next message: Jean: "Access 2000 Runtime Install-on-Demand" 
    Date: Tue, 27 Jul 2021 09:53:42 -0700

    I copied this over and it's still not working. Any other ideas?

    "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?
    >
    >
    >

  • Next message: Jean: "Access 2000 Runtime Install-on-Demand"