Simple text field search

<i><b>Originally posted by : Charles Janco (cjanco@mindspring.com)</b></i><br />I am trying to create a simple form that searches a text field in my Access database. The field contains part numbers that are made up of numbers and letters that vary in length. I was able to get it working by searching by the auto number field but not a text field.<br /><br />Thanks in advance for your help!<br />

<i><b>Originally posted by : steve</b></i><br />check this link<br />http://www.aspalliance.com/glenncook/searchcode.asp<br />this shows how to setup a search. <br /><br /><br />------------<br />Charles Janco at 3/22/2000 11:34:09 AM<br /><br />I am trying to create a simple form that searches a text field in my Access database. The field contains part numbers that are made up of numbers and letters that vary in length. I was able to get it working by searching by the auto number field but not a text field.<br /><br />Thanks in advance for your help!<br />

<i><b>Originally posted by : Charles (cjanco@mindspring.com)</b></i><br />Thanks Steve,<br /><br />I have downloaded that example before. I still cannot figure out what I am doing wrong! I get the error message: "Too few parameters. Expected 1."<br /><br />My code looks like:<br /><br />strPartNumber = trim(ucase(Request.Form("partnumber")))<br /><br />strSQL = "select partnumber, producttagline from webproducts where strPartNumber like '%" & Request.Form("partnumber") & "%' "<br />Set objRS = objConn.Execute(strSQL) <br /><br /><br />------------<br />steve at 3/22/2000 11:35:53 AM<br /><br />check this link<br />http://www.aspalliance.com/glenncook/searchcode.asp<br />this shows how to setup a search. <br /><br /><br />------------<br />Charles Janco at 3/22/2000 11:34:09 AM<br /><br />I am trying to create a simple form that searches a text field in my Access database. The field contains part numbers that are made up of numbers and letters that vary in length. I was able to get it working by searching by the auto number field but not a text field.<br /><br />Thanks in advance for your help!<br />