<html>
I believe the wildcards have to be included in single quotes:<br><br>
Try<br>
<font face="arial" size=2>strSQL = "SELECT tblCustomers.CustomerID,
" & _<br>
<x-tab> </x-tab>"
[tblCustomers]![CustomerNumber] & '-' &
[tblCustomers]![CustomerSite] AS CustCode, " & _<br>
<x-tab> </x-tab>"
tblCustomers.CustomerName, " & _<br>
<x-tab> </x-tab>"
tblCustomers.Address1 & ' ' & "tblCustomers.Address2
& ' ' & tblCustomers.Address3 & ' ' &
tblCustomers.Postcode AS Address, " & _<br>
<x-tab> </x-tab>"
tblCustomers.DepotID" & _<br>
<x-tab> </x-tab>"
FROM tblCustomers " & _<br>
<x-tab> </x-tab>" WHERE
tblCustomers.CustomerName) Like '%" & strInput & "%'
" & _<br>
<x-tab> </x-tab>" ORDER BY
tblCustomers.CustomerName"<br><br>
</font>At 08:13 AM 6/5/2003 -0700, you wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2>strSQL =
"SELECT tblCustomers.CustomerID, " _<br>
&
"[tblCustomers]![CustomerNumber] & '-' &
[tblCustomers]![CustomerSite] " _<br>
&
"AS CustCode, tblCustomers.CustomerName, tblCustomers.Address1 &
' ' & " _<br>
&
"tblCustomers.Address2 & ' ' & tblCustomers.Address3 & '
' & " _<br>
&
"tblCustomers.Postcode AS Address, tblCustomers.DepotID FROM
tblCustomers " _<br>
&
"WHERE (((tblCustomers.CustomerName) Like % + " _<br>
&
strInput & " + %)) " _<br>
&
"ORDER BY tblCustomers.CustomerName;"</font></blockquote><br>
</html>