Hi, I am trying to search a database of Train Times based on the input from a user.

There are 2 drop down boxes, one had a list of Departing points, and the other has a list of Arriving points.

When the user selects the two points I want them to click a SUBMIT button and then the values selected will be used in a SQL statement to return the results, the results need to be returned on the same page.

Can anyone help, I am working on it, but I am sure there is a simple way to do this.

I currently have used javascript to hold the values, but it has got messy.

HELP!!!!!!

Mani

Dim Point_1, Point_2
Point_1 = Request.Form ("point_1")
Point_2 = Request.Form ("point_2")
SQL_Query = "Select fieldname from table where point_1 = " & Point_1 & " and Point_2 = " & Point_2

If they're strings instead of numbers, modify the SQL query accordingly.