Access 2010 Works 2007 Error Me.Browse.Form.Filter = strWhere

[ilikebirds]

So I have the following search code:

     ' If App To
    If IsDate(Me.TermTo) Then
        ' Add it to the predicate - exact
        strWhere = strWhere & " AND " & "MainDB.[Case Terminated Date] <= " & GetDateFilter(Me.TermTo)
    ElseIf Nz(Me.TermTo) <> "" Then
        strError = cInvalidDateError
    End If
    If strError <> "" Then
        MsgBox strError
    Else
        'DoCmd.OpenForm "Browse Issues", acFormDS, , strWhere, acFormEdit, acWindowNormal
        If Not Me.FormFooter.Visible Then
            Me.FormFooter.Visible = True
            DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
        End If
        Me.Browse.Form.Filter = strWhere
        Me.Browse.Form.FilterOn = True
    End If
End Sub

In 2010 Access the search works fine! In Access 2007 I get an error at the Line Me.Browse.Form.Filter=Strwhere


and mouseover reveals: The expression you entered refers to an object that is not...

Any Ideas?

[ssanfu]

Comments inline:

    ' If App To
    If IsDate(Me.TermTo) Then
        ' Add it to the predicate - exact

        'does the function GetDateFilter() add date delimiters?

        strWhere = strWhere & " AND " & "MainDB.[Case Terminated Date] <= " & GetDateFilter(Me.TermTo)
' is there ever a chance that the WHERE string will BEGIN with " AND " ???

    ElseIf Nz(Me.TermTo) <> "" Then
        strError = cInvalidDateError
    End If
    If strError <> "" Then
        MsgBox strError
    Else
        'DoCmd.OpenForm "Browse Issues", acFormDS, , strWhere, acFormEdit, acWindowNormal
        If Not Me.FormFooter.Visible Then
            Me.FormFooter.Visible = True
            DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
        End If

'I have never see this usage of "Browse"
'I would use:

        Me.Filter = strWhere
        Me.FilterOn = True

'        Me.Browse.Form.Filter = strWhere
'        Me.Browse.Form.FilterOn = True
    End If
End Sub

Also, using spaces in Access object names is not considered a good thing to do. It will cause you headaches in queries, forms and reports.