Thanks Imar , you were absolutely right, there was nothing in the query string.Sorry for taking so long to reply.
By the way, I'm trying to synchronise 2 combo boxes.the first combo box has a list of laws from a table in a database called Law and the second combo box has a list of lawSubsections.When a user clicks , say, Law#1 , I want only those subsections that go with law#! to appear in the second combo box.There are already some pieces of info on this in the farest reaches of the web but unfortuneately theye are very fragmantary.Do I need 2 select statements in the same .asp file?
Actually the way I am doing it I am getting the same mistake I got previosly which is Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'lawNo ='.
here is my code :
Dim MyConn, Rs, MyLaw , Rs2 , MyComponent
Rs.Open "SELECT * From Law", MyConn, 1, 2
Rs2.Open "SELECT * From Component where lawNo=" & Request.QueryString("lawNo"), MyConn, 1, 2
<title>Inputting a new Question</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<p><strong>Please use this form to input a new question </strong></p>
<form name="form1" method="post" action="http://pertinax.cms.shu.ac.uk/mmtec/mm32/HandleInputQ.asp"">
<p><strong>Choose a Law</strong>
While NOT Rs.EOF
MyLaw=Rs("lawNo") & " " & Rs("lawText")
<p><strong>Which component of this law does your question most go with?</strong>
While NOT Rs2.EOF
<input type="submit" name="Submit" value="Submit" onClick="mySubmit()">
I hope this is not too irritatingly simple to bother with ,
I am a beginner and the ASP books I've got , which are all half a meter thick are totally rubbish