Why would table columns lose their filtering functionally?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 1009 records in my table. When I try to add one more the first two
columns of my table lose their filtering functionally. The filter screen no
long displays a list of data to select from. The only functionality left is
sorting. The other columns are fine as are other tables in my database.
 
Try a compact and repair. The database might be corrupt.

The best advice though is to not work directly in tables. Instead create a
form and use the filter by form to find records.
 
There is a property on creating the dropdowns - it is normally set to 1000
records.

Tools: Options: Edit Find Tab:
Don't Display Lists where more than this number of records read:

The idea is that if there are more than n records the performance could be
slow and also looking through that many records to find the value is
probably less effective than just typing the value in.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top