i've highligthed and underlined the line that was giving me a nullreference exception.

Hi Thsi is posible only when you PK Field is Identity or some before insert trigger is taking the responsibility of updating the PK filed. Regards :) Tushar kothari

:rose:thank u paddy for helping me out...:)...

I believe user and name are reserved words. Try [user] and [name] instead and see if it helps, everthing else seems ok to me. "Democracy is two wolves and a sheep voting on what to have for dinner" - Ross Edbert Sydney, Australia

it would be a of great help if i could get any help on the Javascript on it thank u

A hyperlink fiels in the database has nothing to do with a hyperlink on a web page. It's only a hyperlink in the form that is used by Office applications. There is nothing built in to create a web link from it. Either read the value from the hyperlink field and split it up into the name and url, or store the informantion as regular text fields. Either way you use the information to put in a regular link on the page. --- b { font-weight: normal; }

is there any other way doing this...i need two feilds in the listbox option...thanks for all the help...im new to this :)... Error Type: Microsoft VBScript compilation (0x800A03EE) Expected ')' <% Set oRs=Server.CreateObject("adodb.recordset") strSQL = "SELECT code ,description FROM projects" oRs.Open strSQL, conn Do while not oRs.EOF if Request.Form("code") = oRs("Code") then Response.Write ("" & oRs.Fields("description") & " " oRs.MoveNext else Response.Write ("" & oRs.Fields("description") & " " oRs.MoveNext end if loop %> bobo... -- modified at 2:22 Tuesday 13th June, 2006