Hi jailin

First I propose you to change your SQL query for this :

 
If txtSearch3.Value Like "[A-Z]" Then SQL = "SELECT * FROM tblcustdet WHERE customername & Street & Suburb LIKE " & "*" & strSEARCH & "*"

but I don't know how to make it display any results
On MS-Access, you need to use recordset object as follows

Dim FindRecordCount  as long 
Dim rstRecords As DAO.Recordset
 
Set rstRecords = CurrentDb.OpenRecordset(SQL)


If rstRecords.EOF Then
      FindRecordCount = 0
Else
      rstRecords.MoveLast
      FindRecordCount = rstRecords.RecordCount
End If
 
rstRecords.Close
Set rstRecords = Nothing

hope it will help you