Vise ID når entry gemmes

Hej

Med koden neders i dette spørgsmål gemmer jeg data fra en form i en database. Er det muligt på samme side at vise det ID der er blevet tildelt, samt putte det ind i et link (tips_details.asp?id=    )?

Jeg kan sagtens vise data der er sat ind i form'en, men det kniber med at få fat i ID'et.

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open="hcb_scales_tips"
strSQL = "Insert into tricks (log, module, tc, subject, description, initials, status, catagory, target) values(now(), '" & Request.Form("module") &"', '" & request.Form("tc") & "', '" & request.Form("subject") & "', '" & request.Form("description") & "', '" & request.Form("initials") & "', 'APPROVED', '" & request.Form("catagory") & "', '" & request.Form("target") & "')"
objConn.Execute(strSQL)
objConn.Close
%>

<%response.write("Module: ") + (request.form("module"))%><br>
<%response.write("Transaction Code: ") + (request.form("tc"))%><br>
<%response.write("Subject: ") + (request.form("subject"))%><br>
<%response.write("Description: ") + (request.form("description"))%><br>
<%response.write("Registered by: ") + (request.form("initials"))%><br>
<%response.write("Catagory: ") + (request.form("catagory"))%><br>
<%response.write("Catagory: ") + (request.form("target"))%><br><br>

Hilsen

Kim