Open Form unfiltered

[DiHo]

I just installed Access 2007 the other day (had 2003 previously) and it
introduced a problem that I can't figure out. I have a form (Form1) with a
button that opens another form (Form2). It used to open Form2 in an
unfiltered state, which is what I want. Since installing Access 2007, it is
now opening Form2 filtered to a single record. I can't even figure out the
logic by which it is choosing this one record. The same thing is happening
with Form3, Form4, etc. I just opened these forms directly from the list of
Forms (rather than with a button on Form1) and the same thing happens. This
is new with Access 2007.

I have a "Show all records" button on Form2, but I (and all the other users
of this database) shouldn't have to use it every time I open the form.

All help is greatly appreciated.
Thanks,
Diane

 

[Allen Browne]

In Access 2007, forms have a new property called Filter On Load.

Open the form in design view, and set this property to No. Save. Close the
form. It should now work.

 

[DiHo]

Allen,
It worked beautifully. You're a life-saver, Allen. How simple it is when
you know all the answers!
Thank you,
Diane