Hallo! My English is not so good, but I hope you will understand me! I am working with a data access page in Access. In this page I have two dropdown list boxes and a search button. The idea with this page is to select two years in the two list boxes and when one press the search button the records which matches against the two years will be shown in the page. The table is called "Events" and the two fields "Year_1" and "Year_2". My goal is to create this with just Jscript or VBScript, but I dont know how to do, so I hope someone wants to help me.

Fntmn!!
You can query the "Events" table with given condition

e.g
sql="select * from Events where Year_1='"&tempyear1&"' and Year_2='"&tempyear2&"'"
set rs=conn.execute(sql)

when search button is clicked get the values from dropdownlist.
hope this will help you


Cheers :)

vinod