Basically, you are filtering your data.
Design a form, using the query as the form record source. Remove the criteria in the query.
Add the fields from the query to the form detail section. Set the form default view to Continuous Forms
In the form header, add the unbound combo box for the territory. (cboTerr)
Add a button in the header. The click event of the button would have code
Button name -> "btnFilter"
Caption -> "Filter"
Code:
Private Sub btnFilter_Click()
Me.Filter = "Territory = '" & Me.cboTerr & "'"
Me.FilterOn = True
End Sub
Add another button to remove filter
Button name -> "btnNoFilter"
Caption -> "Remove Filter"
Code:
Private Sub btnNoFilter_Click()
Me.Filter = vbNullString
Me.FilterOn = False
End Sub
I don't know if cboTerr is a number or text. If cboTerr returns a number, change
Code:
Me.Filter = "Territory = '" & Me.cboTerr & "'"
to
Code:
Me.Filter = "Territory = " & Me.cboTerr
Drat! Late again...