[AccessD] Form Filtering not working

Hi Doris
Thanks for your reply.
I've tracked it down to Jet SP7
After using windows update and installing this - the form filtering stopped
working.
Cheers Tracy

----- Original Message -----
From: "Mike and Doris Manning" <mikedorism at ntelos.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, July 03, 2003 12:12 AM
Subject: RE: [AccessD] Form Filtering not working


> The problem is you have the form reference in quotes.  Try this instead...
>
> DoCmd.OpenForm "Quote", , , "[QuoteNumber] = " & Forms![Quote -
> list]![QuoteNumber]
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tracy
> Sent: Wednesday, July 02, 2003 12:22 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Form Filtering not working
>
>
> Hi Charlotte
> When opening the form using VBA code as below:
>
> DoCmd.OpenForm "Quote", , , "[QuoteNumber] = Forms![Quote -
> list]![QuoteNumber]"
>
> Using Access 2000 on Windows 2000 SP3
>
> Thabks Tracy
>
> ----- Original Message -----
> From: "Charlotte Foust" <cfoust at infostatsystems.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, July 02, 2003 8:31 AM
> Subject: RE: [AccessD] Form Filtering not working
>
>
> > When you say "filter", is that actually what you mean?  It sounds more
> > like you're using some kind of find or seek to locate the record
> > instead, and that isn't the same thing at all.  What version of Access
> > are you using.
> >
> > Charlotte Foust
> >
> > -----Original Message-----
> > From: Tracy [mailto:tracy at ak.planet.gen.nz]
> > Sent: Tuesday, July 01, 2003 12:23 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Form Filtering not working
> >
> >
> > Hi Listers
> > I'm having a weird problem with one of my forms.
> >
> > When filtering the form, the filter works the first time ie: it goes
> > to the correct record. But the second and subsequent times it remains
> > at the record that was filtered the first time.
> >
> > I know the code that I use to filter the record is 100% correct as the
> > app has been used for the last 5 years and this code hasn't been
> > changed.
> >
> > Has anybody come across anything like this before ?
> >
> > I have tried removing the filter from the form then applying the new
> > filter criteria in code but this has the same result as above ie:
> > works the first time but not the second and subsequent times.
> >
> > Any help appreciated
> >
> > Cheers Tracy
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com