Update Combobox values based on another Combo 1

[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

 

[schase]

http://www.tek-tips.com/faqs.cfm?spid=333&sfid=1498&CFID=55925817&CFTOKEN=84689958

"Insert witty remark here"

Stuart

 

[robrichardson]

Worked a treat, thanx Stuart