This is all client-side javascript, and has nothing to do with ASP, or
Access.

Once the page has been rendered on the client, you can't do further
server-side processing until you issue a new page request (not without using
remote-scripting, RDS, ActiveX, Java or similar)

You would need to move all the data to the client, then use javascript to
populate/show the second select box. I suggest you ask on a javascript list.
There are several at http://p2p.wrox.com/

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "NTLworld" <hcs@c...>
Subject: [access_asp] Grabbing <Select><Option> data prior to submit


: Hi,
:
: I have a db [ODBC] filled list box.
:
: Prior to it being "Submitted" I require to now the text within the list
box
: either,  that that has already been selected by the client or by default.
:
: This all in order to pass it to another SQL statement where it would be
used
: in the WHERE statement prior to that SQL filling a further list box.
:
: I must have half a dozen books on asp, vb4, xml, html etc., but all are
: reluctant to give up the necessary knowledge all as if it were not
: available. Is it?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~