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??