[AccessD] Re: need help with filter code

Hello Robert,

the form is based on the _1 query, and i allready places me.requery in the code , between the last line of code you gave me and the End Sub.

Pedro Janssen

In antwoord op:

> From: "Robert L. Stewart" <rl_stewart at highstream.net>
> To: accessd at databaseadvisors.com
> Cc: pedro at plex.nl
> Date: Fri, 20 Feb 2004 07:18:25 -0600
> Subject: [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
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>