Dynamic List Box for Search Page

I have a search page with state and city drop-down list boxes. Each list box
pulls it's options from a record set. Righ now I query my database and return
all states and all cities to choose from. I would like the city list box to
only display cities in the selected state (from the state list box).
What's the best way to dynamically generate the city list based on the state
selection? I tried just sorting my 'city' record set based on the 'state' form
value, but it doesn't update the city list since the form has not been
submitted. Any ideas? Thanks in advance for any help, Mark...... :cool;

http://www.kermy.com/Extensions/DynamicDDL.asp

I think this may be what you are looking for. I have used it a couple times successfully.