Problem with "filter by form"

  • Thread starter Thread starter bill.baker
  • Start date Start date
B

bill.baker

I have set up a table with data in Microsoft Access. I
also have a book with its own data to learn Access. When
I am using the book, and I open a table, and I click on
filter by form, I get a form and when I click in any part
of it, I get a drop down menu which has all of the
individual entries in that part of the table, which is
what is supposed to happen. However, when I open my own
table, and I click on filter by form, and I click on any
part of it, I get a drop down menu which simply has two
entries, "Is null" and "Is not null." I don't get the
menu which has all of the entries of that part of the
table. Which I need. What have I done wrong, and what
can I do to solve it?
 
Hi Bill,

One possibility:

Double-check settings in Options/"Edit/Find" tab
for Filter by form defaults.

If Show-list-of-values-in Checkboxes
are checked for indexed and non-indexed
fields, it could be you need to raise default
"1000" to something larger.

At least in my experience, if I had more
than 1000 records, I would get "Is Null"
and "Is Not Null" until I changed this default.
 
Back
Top