Open Form unfiltered

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
 
A

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.
 
D

DiHo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top