I am trying to search an Access database using an ADO data control, and am having problems. I have the following code:

Dim NewSearch As String
NewSearch = InputBox("Enter User Login", "Search")
If NewSearch = ("") Then Exit Sub

adoLogin.RecordSource = "SELECT * FROM Logins WHERE Login LIKE '%" & NewSearch & " % '"

adoLogin.Refresh

It says I have an error in my FROM statement, and I can't see it at this point. I have tried several ways. Someone please help