Drop Down passes info to a text box

<i><b>Originally posted by : Steve (smertz@countryjunction.com)</b></i><br /><br />I am trying to get a Drop Down list to pass info to a text box in the same form. It is used in a search. I am trying to have the drop down list (representing a column in the DB) pass the list selection into a SQL statement that then search the selected column for what was enterend in the text box.<br /><br />Thanks for any help you may have.<br />Steve

<i><b>Originally posted by : (smertz@countryjunction.com)</b></i><br /><br />Hi <br />What I found was in the drop down list selection box if you have 2 words in space between and you are trying to get that value to the text box whether in the same page or the next page the space is considered as end of the string.<br />So in order to avoid this you can have an underscore between the 2 words(if any) in the drop down selection box so that your query statement runs without any problem<br /><br /><br />------------<br />Steve at 2/2/00 12:12:44 PM<br /><br /><br />I am trying to get a Drop Down list to pass info to a text box in the same form. It is used in a search. I am trying to have the drop down list (representing a column in the DB) pass the list selection into a SQL statement that then search the selected column for what was enterend in the text box.<br /><br />Thanks for any help you may have.<br />Steve