Search results

Paul you are my hero that work perfectly, thank you for all the help I really appreciate it!

What I am trying to achieve is having one box which will allow the user to search by either MemberID, Forenames or Surname all in the same textbox, I was hoping that if text was used WHERE MemberID=Potter would be ignored at it would search for the other two? For example a user might not put...

Hey thanks for the Reply, If I search the table for someone with the Surname Potter, by typing Potter into the txtSearchMembers textbox then the Enter Parameter Value box will look like this: (see attachment) The Immediate window shows this SELECT * FROM Member WHERE MemberID=Potter or...

Hey guys I am trying to do a pretty simple SELECT query but I keep getting the Enter Parameter Value pop up box, where am I going wrong in my statement? Private Sub btnSearchMembers_Click() sql = "SELECT * FROM Member WHERE MemberID=" & txtSearchMembers.Value & " or Surname='" &...