Before filtering I was using this code to search in the form...both filtering and below code working fine for whole form...but with slow down almost 2 minutes...while the query open itself within 4 seconds...only search is issue...
Code:Dim strSearch As String Dim strText As String StrText= Me.txtSearch.value StrSearch = "SELECT * From Qry_tsb_Sql Where EmployeeNumber =" & chr (34) & strText & chr (34) Me.RecotdSource = strSearch