I have a combo box in a form to filter the report filed,
my requirement is to only filter the report, but it shouldn't open it,
because that work will be done after clicking another button where date will be filtered.
but unfortunately this is not working. Anyone pls help me.
Private Sub cmdFilter_Click()
Dim StrWhere As String
Dim strreport As String
strreport = "OT details"
StrWhere = "[Area]" = Me.cbolocationbrief & "'"