option value displayed in textarea

[sarjenwd]

Hello,

ASP newby here. I have created a database with two data fields and an auto number ID in Access. I have set up an select box to display the categories field in the database and a textarea to display it related value (multiline, multi column).

I can't seem to get the selected value from the select box to display in the textarea when selected. Right now the database info show from the first record shows but won't change when the option is selected.

The database is in 1 table, category and categoryInfo both on the same autonumber ID.

How do I make the textarea data field (categoryInfo) change when the option (category) from the select box is chosen?

Thanks.

[exoskeleton]

hi, you mean everytime you select in the category the textarea also will change without submitting the page?

[sarjenwd]

Yes, just select the option and view its information in the text area below, this is on the same page.

Does there need to be a submission to the database or the page to display the relevant information?

Thanks

[sarjenwd]

Ok,

I know that there doesn't have to be a form submission because I'm not updating the database in any way, in fact it doesn't matter if the drop down box and / or the text area are in a form even though they are form elements because there is no updating.

The information is coming from a record set. If I need to provide more info please let me know but I am still not able to select a category in the drop down and see the displayed information for that category in the textarea.

Thanks