MS Access: Order of Events in event ApplyFilter (ADP Project)

Posted by Jose Valdes on Stack Overflow See other posts from Stack Overflow or by Jose Valdes
Published on 2010-04-20T22:06:31Z Indexed on 2010/04/21 7:13 UTC
Read the original article Hit count: 259

Filed under:
|
|

I'm having problems with the execution of ServerFilterByForm in Access 2003 When I apply the entered filter it returns the requested data but after it appear on screen (Form) it disappears. Don't know why this is happening

Does anyone had the same problem? How can it be solved? Heris is part of the code

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer) Dim stSql As String

If Len(ServerFilter) > 0 Then
    stSql = "SELECT * FROM v_InitialReviewQuery " & _
            " WHERE " + ServerFilter & _
            " ORDER BY acctnumber"

Else
    stSql = "SELECT top 1 * FROM v_InitialReviewQuery ORDER BY acctnumber"
End If


Me.RecordSource = stSql

End Sub

© Stack Overflow or respective owner

Related posts about ms

Related posts about ms-access