[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