The problem is the filter is not working?????

[df13427]

HELP!!!!!It driving me crazy

The user picks a monitor from the monitor drop down when they click on the report button they should only see the records from that monitor. check91 if they click that then they will see all records for voicemail category.everything is accessed from a switchboard type form. the filter does not work???

This is the code in the report event on_open:

Private Sub Report_Open(Cancel As Integer)
Dim rpt As Report
Dim k As String
Dim strfilter As String
Set rpt = Reports!Voicemail_r
 
Dim d
d = Forms!Switchboard!MonitorCombo.Column(1)
'Stop
        k = "VoicemailQ.MonID"
        If Forms!Switchboard!Check91 = True Then
        strfilter = BuildCriteria(k, dbInteger, ">0")
        ElseIf Forms!Switchboard!Check91 = False Then
        strfilter = BuildCriteria(k, dbInteger, d)
 
'Set FilterOn property; form now shows filtered records
        rpt.FilterOn = True
        rpt.Filter = strfilter
 
End If
End Sub

[NeoPa]

Is this supposed to be a joke? Most of the code (All the important code) is contained in BuildCriteria() which you haven't included and your explanation of the problem doesn't have a recognisable sentence in it.

If you want some help, may I suggest you start with a question that has the very basics at least. If you're as desperate as you say, then surely two minutes of your time is not too much of a commitment for you.

[df13427]

The problem is line 17 and 18. the build critieria does what it is suppose to do. In order to filter the records I believe the filter property should be on?? the issue is when I click on the reports button the filtor in line 17 and 18 does not happen thus effecting lines 13 and 14. These lines are suppose to give me just the records for what ever is selected in d = Forms!Switchboard!MonitorCombo.Column(1). Am I using the right code or arguments for the Filteron method/property.

[Stewart Ross]

You have the FilterOn property set before you apply the filter in lines 17 and 18- switch those two lines round:

   rpt.Filter = strfilter 
   rpt.FilterOn = True

Beyond that, if your filtering isn't working you'd need to show us an example of the filter string you are applying to the report, because the most likely fault then is within the filter you are applying to your report.

You are at present telling us to take on trust that the output from your Buildcriteria function is OK, but as NeoPa advised this is the bit that is actually doing all the work - you should never assume that bespoke code can't be at fault, or you'll spend unnecessary time looking at the wrong things - and so will we!! It is simple to post an example of the filter string that is really being applied, and then we'll know for sure whether applying it can work or not.

-Stewart

[NeoPa]

df13427:
The problem is line 17 and 18. the build critieria does what it is suppose to do.

So, let me see if I have this right.

You want help from us, but when we don't say what you want to hear, then you (rudely) ignore what we say and tell us how it should be done. Interesting approach. I'll observe with curiosity as you solve this without help then :D

By the way, if you ever get as far as the first obvious step (a question with the basic data in) I'll be more than happy to help. Good luck.