D
Dewey
I have a form that displays project details and includes a couple combo boxes
for filtering records. One of the combos filters records by project manager
and one filters by project area (eg. research, communications, education,
etc.). The AfterUpdate event of each box is similar to the following:
Private Sub cboFilterManager_AfterUpdate()
Me.Filter = "[strProjectManager] = '" & cboFilterManager.Text & "'
Me.FilterOn = True
End Sub
I would like to:
a.) Have each combo box include the other's criteria if a value has been
selected, so that the user could sort by project area and then further sort
by a particular project manager in that area - and vice versa.
b.) Filter each combo box by the other if a selection has been made. Thus,
if a project area filter is selected, only the managers involved in that
project area will appear in the project manager combo box - and vice versa.
It's the "vice versa" parts that I'm really unsure about.
Thanks in advance, and thanks again to all those who provide assistance
here. If it weren't for you, I'd be even more clueless than I am now.
for filtering records. One of the combos filters records by project manager
and one filters by project area (eg. research, communications, education,
etc.). The AfterUpdate event of each box is similar to the following:
Private Sub cboFilterManager_AfterUpdate()
Me.Filter = "[strProjectManager] = '" & cboFilterManager.Text & "'
Me.FilterOn = True
End Sub
I would like to:
a.) Have each combo box include the other's criteria if a value has been
selected, so that the user could sort by project area and then further sort
by a particular project manager in that area - and vice versa.
b.) Filter each combo box by the other if a selection has been made. Thus,
if a project area filter is selected, only the managers involved in that
project area will appear in the project manager combo box - and vice versa.
It's the "vice versa" parts that I'm really unsure about.
Thanks in advance, and thanks again to all those who provide assistance
here. If it weren't for you, I'd be even more clueless than I am now.