.
Query Search - useful when converting to Access 2010

Function QuerySearch(SearchString As String)
Dim db As DAO.Database
Dim qd As QueryDef
Set db = Application.CurrentDb
For Each qd In db.QueryDefs
    SQL = qd.SQL
    If InStr(1, SQL, SearchString) Then
    Debug.Print SearchString & " used in query - " & qd.Name
    End If
Next
End Function