I have created a search function that allows the user to select up to 4 different criteria to search the database. I have developed the sql statements. The statements use multiple joins between tables. The various search options make it too complex to apply the criteria using a single sql statement. Is it possible to use a recordset on the based on the first criteria and then apply the next criteria to the first recordset and so on until the initial recordset is filtered a max of 3 times.