I do something like this. User selects field in combobox. Then VBA code changes the RowSource of second combobox to only show DISTINCT values from the selected field. Something like:
Code:
Me.cbxFor.RowSource = "SELECT DISTINCT " & Me.cbxField & _
" FROM Projects INNER JOIN Submit ON Projects.ProjRecID = Submit.ProjRecID" & _
" WHERE Not " & Me.cbxField & " Is Null " & _
" ORDER BY " & Me.cbxField & ";"
Now applying the selection of the second combobox as filter criteria gets rather complicated if the fields are different data types. Fortunately, not dealing with number data types on this particular form.
I have comboboxes for text type fields and values then textboxes for input of date range. VBA code conditionally builds the criteria string. Review http://allenbrowne.com/ser-62.html
Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention. If you do, code will have to be modified so all object names will be enclosed in [ ] characters in the compiled SQL string.