Glad to see you found a solution. I've noticed this behaviour before but
i'm
not always to reproduce this. This makes it hard to define it as a bug.
Personally i'm not a big fan of the send keys option but if it does the
trick
for you right now it takes care of the problem. I will dive into it
however
because i'd really like to know what causes this and how we can bypass it
in
the future.
Thanks for the feedback. (and yes we do need our sleep ;-)
--
Maurice Ausum
"fred75" wrote:
> Hi again,
>
> Just tried your solution:
>
> me.filter=false
> and the option filter on load is effectively set to no.
>
> (in fact I tried those before, even used me.FilterOn=False)
> but does not work, looks like the SendKeys "{F5}" is, so far,
> my best bet !!
>
> Off to bed (it is 02:03 AM)
> Thanks Maurice
>
>
>
> "Maurice" wrote:
>
> > Hi fred,
> >
> > Tried to reproduce your problem and could do so only once. When I used
the
> > me.filter=false setting i got rid of the sql statement. so give that a
try.
> >
> > So -> me.filter=false
> > and not -> me.filter =""
> > also make sure the option filter on load is set to no.
> >
> > hth
> >
> > --
> > Maurice Ausum
> >
> >
> > "fred75" wrote:
> >
> > > Thank you Maurice,
> > > Tried all that, but no success !
> > > When I click on the command button I use the following:
> > >
> > > Me.FilterOn = False
> > > Me.Filter = ""
> > >
> > > DoCmd.ApplyFilter "rF_MembresSelect"
> > >
> > > this query (used as a filter on the opened form) appears as a SQL
syntax in
> > > the Filter (Properties) of the form and remains there.
> > > If I open the form in Design Mode and clear this "Filter", and
revert back
> > > to Normal Form, then it is OK (only once - the filter remains after
I select
> > > data in the combos and that's my problem, under the previous
versions of
> > > Access, I never had this problem - is this a "bug" with 2007 ?)
> > >
> > > appreciate your help
> > > fred
> > >
> > >
> > > "Maurice" wrote:
> > >
> > > > Have you tried
> > > >
> > > > me.filter=""
> > > > me.filteron=false
> > > >
> > > > see if that helps
> > > > --
> > > > Maurice Ausum
> > > >
> > > >
> > > > "fred75" wrote:
> > > >
> > > > > Hello to all,
> > > > > Used synchronized combo boxes under Access 97, 2000, 2003, to
filter a form
> > > > > in continuous mode.
> > > > > After selecting items in one or more combos, using a command
button, I
> > > > > filter the form by calling a query. Used to work fine with
previous Acces
> > > > > versions, when changing the selection, the filtering was updated
and new
> > > > > results applied.
> > > > >
> > > > > However, with Access 2007, it works fine the first time, then I
keep on
> > > > > getting the same filter (the filter is displayed in the
Properties: filter
> > > > > (in SQL form).
> > > > >
> > > > > Tried to eleiminate the filter by: docmd ShowAllRecords before
calling the
> > > > > query,
> > > > > but it does not work)
> > > > > Question: how do I reset the filter ?
> > > > >
> > > > > thanks for your help
> > > > >
> > > > > fred - Paris - France
|
