I'm hoping somebody can help on this one. I'm pretty new to ASP but am having to try and get help as I'm on a deadline at work to finish this. I've created an Access database and am using ASP to add and view records via a web form. I now want my users to be able to filter the records based on keywords they enter into a form. This is where I've come unstuck. My "View Records" recordset has been opened as a SQL statement. Therefore, in order to filter this I'm going to have to pass additional LIKE clauses into the already existing WHERE clause in my statement. How can I pass the contents of the form into my SQL statement? I'm assuming I'll have to declare the form somewhere so that I can use this in the SQL statement. I can provide the source code if it helps.
Cheers
Welshsteve
Cheers
Welshsteve