choked filter

i am using filter by form to view records by their machine code. if there are less than thousand records in the table, then in the filter drop down list, i can choose the machine code, and view all records matching that code

however, if the records in the table exceed thousand, then in the filter drop down list i only get null or not null. i can no longer choose the machine code.

it there any limit on records for filters. what should i do??
champsAsked:
Who is Participating?
 
nico5038Connect With a Mentor Commented:
Found in the Tools/Options window under the Edit/Find tab the field to set the number of displayed recordmax.
This can be enlarged to 32.000 but that's the real maximum.

Nic;o)
0
 
nico5038Commented:
If the MachineCode is the main search criteria you could add a combobox based on a "SELECT DISTINCT MachineCode From YourTable;"
Thus you get all distinct codes and you can use the afterupdate event to place the selected value as a filter.

Idea?

Nic;o)
0
 
champsAuthor Commented:
i am not using forms or anything...this is directly from the open table...cant i directly do something...?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.