Using one combobox value to update another Problem

[robrichardson]

Hi

I've an ASP page which contains two forms. Both forms contain a combo box.

The first combo contains a list of all users, the second (initially) contains a list of all properties. At first the user may select either user or property and get a list of data correspoding to either selection.

I would like to introduce a button which when clicked will take the value selected in the first combo and populate the entries in the second box to match only that users properties.

I think I need to update the recordsets source. i.e.

The second box (before click)

SELECT * from Property

after click

SELECT * from Property WHERE User= first combobox value

Hope that makes sense

 

[roblasch]

You will have to make a trip to the database to retrieve the new info and refresh the page each time a user wants to update. My question is this. How much data are you talking about? If you could load it initially then you could refresh the second combo box with javascript, eliminating the trip to the server. If not, then your first thought is correct. Just call the same page and run the query with the first combo value like you say.