how do you transfer a field value in the link to another page.
Let me explain what I am trying to do

I have a field name called CAD # and I linked this value if it is true. But The page I linked is suposed the get the value of CAD #, but I doesn't.

Should I put some codes in the page where the link is , or in the page where the CAD # id being called.

Link Page:

if kayitseti.fields("Incident Report")="True" Then

   response.write("<td align=center> <a href='" &("incident.asp") & "'>" & kayitseti.fields("CAD #") & "</td>")
   Else
   response.write("<td align=center>" & kayitseti.fields("Incident Report") & "</td>")

  End If

Incident.asp:

<%


Set baglanti=Server.CreateObject("ADODB.connection" )
baglanti.Open "driver={microsoft access driver (*.mdb)}; DBQ=" &Server.MapPath("db/db2.mdb" )
SQL="select * from [TBL9- Reports] Where [CAD #]='"& [CAD #]&"'"
Set kayitseti = baglanti.Execute(SQL)
%>

<table border="0" width="100%">
  <tr>
    <td width="23%"><img border="0" src="images/badge7pntsml.gif" width="125" height="121"></td>
    <td width="77%"><b>Incident - Report for:</b>
      <p><b>CAD # :</b>
      <%
      response.write( kayitseti.fields("CAD #") )
      %>
      </td> .......

 I dont know where to start. I tried INNER JOIN but it did not work

It looks like the parentheses are messing up your link. Try this:

If kayitseti.Fields("Incident Report").Value ="True" Then
Response.Write("<td align=""center""><a href=""incident.asp?CAT=" & kayitseti.Fields("CAD #").Value & """></td>")


This will write out a link to incident.asp and passes the CAT # number in the QueryString, like this:

incidient.asp?CAT=1234
incidient.asp?CAT=4321

On incident.asp you can retrieve the value again:

Dim CatNr
CatNr = Request.QueryString("CAT")

If I were you, I'd rename the Cat # column. Using spaces and special characters in column names is going to get you in lots of troubles.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you,
It worked,:D
You made my day