[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