filter report

[Ravi Kumar]

dear all,
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 & "'"
End Sub

 

[June7]

Can't change filter of a report open in PrintPreview.

So if report is in ReportView:

Reports![OT Details].Filter = "[Area]" = Me.cbolocationbrief & "'"
Reports![OT Details].FilterOn = True

 

[Cronk]

Ravi


If Area is a text field, there is a missing quote there.

... "[Area]='" & Me.cbolocationbrief & "'"

 

[Ravi Kumar]

dear june7,
where to apply this ??

 

[Ravi Kumar]

Ravi


If Area is a text field, there is a missing quote there.

... "[Area]='" & Me.cbolocationbrief & "'"

hello sir ,
should I do this using expression builder to the filed in my report , because in vba after button click it is not working.

 

[Ravi Kumar]

now it is giving error 2451,
I don't want to open my report after clicking this button (if this sentence helps you).

 

[June7]

Code goes behind button on form or combobox AfterUpdate event.

What is the message of error 2451?

 

[Ravi Kumar]

Code goes behind button on form or combobox AfterUpdate event.

What is the message of error 2451?

It is saying I am trying to run the code for the report which is not open.

 

[June7]

That is a clear message.

Report must be open.