Hi

On the assumption that the query you have shown in your initial post is the rowsource for your list box, if you want only District 1 records to be displayed, you have to include this value (ie 1) in the District column for each Criteria row specified in the Query Designer. For instance, the Criteria row with the selection in the Name column should also have a 1 specified in the District column.

The SQL generated by this is probably going to look something like the WHERE I have already posted (I should have explained it as per this post right from the get go), or Access may modify it to look like the alternative suggested by grovelli. Faced with this problem I would probably manually alter the SQL as per grovelli's method.

All the best.