Filter by Form issue

G

George Wilson

I am currently using Access 2002 on a Windows XP system. I
have a database I have been using for over a year. I have
been using the "Filter by Form" feature to filter records
and up until now it has been working fine. Now when I use
this feature on this database, the only drop down items in
the form are "Is Null" and "Is Not Null". I can apply a
filter by typing in a value, but there are no longer
selections in the drop dows other than listed above. Is
there a form attribute I may have changed that would cause
this behavior? Any suggestions?
TIA
George
 
A

Allen Browne

Try:
Tools | Options | General | Edit/Find

Check the boxes for the "Local Indexed" and "Local non-indexed" fields, and
set "Don't display lists ..." to a big enough number.
 

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

Filter by form in linked table database 2
Filter by Form problem 2
Filter by form Listing 1
Form filter combo box choices are Is Null/Is Not Null 3
clearing persistent "filter by form" selections 1
Resetting the form filter filter for a new report 4
text box filter by form 1
Form Filter will not delete 2

Top