i have a form with four combo boxes and two radio button boxes.
combo_PR
combo_PN
combo_CC
combo_FT
each of the combo boxes above reference a field (respectively):
pr
pn
cc
ft
for each combo box, I use (obviously changing the combo_pr and pr for each event):
If IsNull(Me.Combo_PR) Then
DoCmd.ApplyFilter "[pr]", "[pr] like '*'"
Else
DoCmd.ApplyFilter "[pr]", "[pr] = '" & Me.Combo_PR & "'"
End If
and this works fine individually. however, if I filter on combo_PR and the attempt to add another filter like combo_PN, the query appears to reset/forget the combo_pr filter and just filter for combo_pn. of course, I'd like to keep some nulls in there for when folks want to filter on just one or two criteria rather than three or four.
what is the bet method to apply the filtering to focus on multiple combo boxes?
normally, I set the criteria within the query to be:
Like IIf(IsNull([Forms]![frm_fr]![Combo_pr]),"*",[Forms]![frm_fr]![Combo_pr])
and this has worked best, but for whatever reason, within this query, using this slows it down tremendously to where it is not useable.
any insight would be greatly appreciated!
thx!
combo_PR
combo_PN
combo_CC
combo_FT
each of the combo boxes above reference a field (respectively):
pr
pn
cc
ft
for each combo box, I use (obviously changing the combo_pr and pr for each event):
If IsNull(Me.Combo_PR) Then
DoCmd.ApplyFilter "[pr]", "[pr] like '*'"
Else
DoCmd.ApplyFilter "[pr]", "[pr] = '" & Me.Combo_PR & "'"
End If
and this works fine individually. however, if I filter on combo_PR and the attempt to add another filter like combo_PN, the query appears to reset/forget the combo_pr filter and just filter for combo_pn. of course, I'd like to keep some nulls in there for when folks want to filter on just one or two criteria rather than three or four.
what is the bet method to apply the filtering to focus on multiple combo boxes?
normally, I set the criteria within the query to be:
Like IIf(IsNull([Forms]![frm_fr]![Combo_pr]),"*",[Forms]![frm_fr]![Combo_pr])
and this has worked best, but for whatever reason, within this query, using this slows it down tremendously to where it is not useable.
any insight would be greatly appreciated!
thx!