[AccessD] Re: need help with filter code

Pedro,

Is the form based on the _1 query?

Are you filtering the current form, or
opening a different form from the button?

If you are filtering the current form. you
need to do me.requery.  If it is a new form
you are opening, then you just need to check
and make sure you are using the _1 query and
not the _0 query.

I use this for reports and forms all the time
to filter the information for them.

If you continue to have problems with it, send
me a zip with the forms, querys, and tables
that are involved and I will look at it for you.

Robert

At 09:20 PM 2/19/2004 -0600, you wrote:
>Date: Thu, 19 Feb 2004 22:24:54 +0100
>From: "Pedro Janssen" <pedro at plex.nl>
>Subject: Re: [AccessD] Re: need help with filter code
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <006601c3f72e$f2d75360$f4c581d5 at pedro>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Hello Robert (and others),
>
>i used your code to filter on multiple fields.
>I works, but in the query, not in the form.
>When i enter a value in the txtbox and click the command button,
>nothing happens. Looking in the query_1 i see that the Like ... Or statement
>is placed in the fields. Looking in the queryview it also filters the right
>values.
>Then returning to the form and looking in its view, then it is showing the
>exact
>values. I tried to requery and refresh in the code, but nothing changed.
>Do you know how this is possible?
>
>Pedro Janssen