Hey,

I'm trying to create a simple user search fuction on a website. For example i have on the form:

Forname: Jon
Surname: Doe

Button: Search

So, i',m using an query to search the database and the connection is all good however i can seem to get the query to recognise the values in the textboxes?

here is the query

SELECT Admin, DateOfRequest, ForeNameOfUser, SurNameOfUser FROM LOG_Requests WHERE (ForeNameOfUser = '&Forename') AND (SurNameOfUser = '&Surname')

i have stored the textbox values in strings Forename and Surname

i know its some thing to do with the syntax "&Forename" but i can't find the answer anywhere.