I have a form and I want to pass one field of data from that form as a parameter to a recordset that would be used to create a dynamic table. I don't want to submit the form because I need to create the dynamic table to get information to fill out other fields in the form before submitting the form. Is there a way to do this?

The text field would have the the item number I want to use in an SQL query to create the parameter. Ideally I would be able to click on the text field in the form to send to the recordset. Something like onclick send field either as a string or form field to the other ASP page that has the query/recordset.

Using CS3 Dreamweaver. Any help is greatly appreciated.