"Bart Schelkens" <BS********@hotmail.com> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...
Is there a way to have the desired effect whitout having to perform a
submit ?
Yes, but I'm going to get flamed for suggesting it :-)
But before I do, you must have a REALLY good reason for not performing a
submit, because that is by far the best way to achieve what you want.
However, if you really don't want to submit, and the datasets in question
are relatively small, you could create a JavaScript client-side array in the
<HEAD> of your page which contains all of the records in the related combo.
Then, when the user selects a different option in the first combo, you call
a client-side JavaScript function which clears the options from the second
combo and repopulates it with only thos options which relate to the
selection in the first combo.
This is not a good idea for several reasons:
1) The array is likely to be large, which will slow the initial load of your
page.
2) If a new option is added to the database, it will not be picked up until
the page actually is refreshed.
Don't do it unless there is a compelling reason to do so...