I've managed to filter my continuous table with one field, so I know the basic method is correct, but this second field I want to filter by insists on including the auto-number PK in the row source of the combo box when I build out its row source query. If I remove the ID from the row source query, the combo box displays a blank list. If I include it, it shows the correct list, but it does not correctly match the value to the field I want to filter by: it returns no results, which to me indicates that it is not trying to match the correct field in the row source query.
When I look at the result of the row source query without the PK, it does produce the correct list that I want the combo box to display, so I am confused why the combo is not displaying it. Does the PK need to be included? Do I set the bound column to 2 if the PK is 1?
I hope this makes sense, I can include pictures and code if necessary.