I have a databse with some fields. fields= mobnr,enamn,fnamn,telnr. I want to have an listbox where i can select the field name and then a textbox where i can search for example the number. I wrote an Sql query like this:

SELECT * FROM database WHERE '%listbox%' LIKE '%searchword%'

param:
listbox % Request.QueryString("listbox"
searchword % Request.QueryString("searchword"

If i hardcode the sql query like:

SELECT * FROM database WHERE mobnr LIKE '%searchword%'

it will work, but not when i have the listbox in the script.,,

/Henrik

Try making the whole WHERE clause dynamic. e.g.

strSQL = "WHERE " & Request("ListBoxName" & " LIKE '%" & Replace(Request("SearchBoxName", "'", "''" & "%'"

Then:

RecordsetName.Source = "SELECT * FROM TableName " & strSQL

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

ok, i will try now......

/H

Im using UD 4, how do implemet this into it., can i write this srtSql direct in the codeview.

/Henrik

Yes, set up a standard recordset using the data bindings window, then modify the relevant lines of code directly in code view.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanx, it works great.!