Query using input and listbox

[exaccess]

The query below is supposed to accept some characters from the user and bring up a list of records satisfying the criteria. TelephoneAAA is a table with many columns. The query does not give any error message receives input from user runs quietly and does not give any result. I know that the table contains sufficient data. Probably I am missing something obvious but what.

RowSourceQy = " SELECT * from [TelephoneAAA] " & _
            "WHERE (([TelephoneAAA].[SOYADI]) Like ((' * ')+ [Word] +(' * '))) OR " & _
            "(([TelephoneAAA].[ADI]) Like ((' * ')+[Word]+(' * '))) OR " & _
            "(([TelephoneAAA].[ADRES]) Like ((' * ')+[Word]+(' * ')))" & _
            "ORDER BY [TelephoneAAA].[SOYADI], [TelephoneAAA].[ADI], [TelephoneAAA].[TEL];"

 

[pbaldy]

You might find this helpful:

http://www.baldyweb.com/ImmediateWindow.htm

Offhand, have you tried removing the spaces around the wildcard character?

 

[exaccess]

I removed the spaces and it worked. Perfect. Thanks.

 

[pbaldy]

Happy to help!