Where Clause Being Added to Select Statement

[JamesJ]

After filtering records using a combo box based on a lookup table,
and then closing the form there are times when Access 2007 adds
a Where clause to my select statement in the Record Source of the form.
Any one know why this is so??

James

 

[M Skabialka]

I have also seen the same problem when I click on a control on a form and
filter for some attribute I want to look at quickly, then forget to remove
the filter before closing the form. The filter becomes part of the
properties of the form, even though I was not prompted to save changes ot
reminded that the form was filtered and will be from now on. I have had to
go into design mode and remover the filter from the form properties. This
is a serious malfunction!

 

[JamesJ]

In my case I use a split form. And have noticed that when I pull down (or
up)
the Splitter Bar and close the form it will ask me if I wanted to save the
changes
to the design of the form. I assumed it was only referring to the movement I
made with the Splitter Bar, but apparently not. If there is a filter applied
it
will save it.

James