i want to update my record but theres an error....

Syntax error in UPDATE statement. line 11. the code is

<%

MsgNo=request.querystring("MsgNo"

set con = server.createobject("ADODB.Connection"
scon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".././dbase/thesis.mdb" & ";"
con.open scon
a= Trim(request("passcode")

sql= "update tblOJTStud set Password= '"&a&"' where StudID="&StudID
con.execute(sql)

Response.redirect "adminOJTshowStudmain.asp?sortby=StudID"

con.close
set con=Nothing
%>

Can somebody help me with this?? Any help is more than appreciated! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

you call a variable here: StudID= "&StudID
But I don't see where you define the StudID

Try adding this at the start of your code
<b>
Dim strStudID
strStudID = scon.Fields.item("StudID".Value
</b>
and the change this
<b>
sql= "update tblOJTStud set Password= '"&a&"' where StudID=" & strStudID
</b>