Hi KC!
I was looking through some of the work I've done with something similar and while I couldn't find anything EXACTLY like your problem, I did find something that you might be able to use.
I have a Search form on which I have a combo box that lists all the departments in our company.
When I select a Department from the combo box & click the 'Search Department' button, it opens another form that displays all records for that one department.
Here's the code behind the Search Department button:
Code:
Private Sub cmdDepartment_Click()
ClearValues ("Department")
Dim Department, Dept As String
Department = "[Department]=" & "'" & Forms!Search.Controls!cmbDepartment & "'"
DoCmd.OpenForm "Master_Datasheet", , , Department
End Sub
This might give you some ideas. I hope it helps.
If it doesn't, I'll keep trying to find a solution for you.