Open Form unfiltered

  • Thread starter Thread starter DiHo
  • Start date Start date
D

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
 
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.
 
Allen,
It worked beautifully. You're a life-saver, Allen. How simple it is when
you know all the answers!
Thank you,
Diane
 
Back
Top