<div>
If the MachineCode is the main search criteria you could add a combobox based on a &quot;SELECT DISTINCT MachineCode From YourTable;&quot;<br />
Thus you get all distinct codes and you can use the afterupdate event to place the selected value as a filter.<br />
<br />
Idea?<br />
<br />
Nic;o)
</div>


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)

<div>
i am not using forms or anything...this is directly from the open table...cant i directly do something...?
</div>


i am not using forms or anything...this is directly from the open table...cant i directly do something...?

<div>
<div class="content wysiwyg-content">
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<br />
<br />
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. <br />
<br />
it there any limit on records for filters. what should i do??
</div>
</div>


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

choked filter

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.