I need to convert a data element from a web page table into an MS Access input parameter and then run another MS Access query.

I have an ASP web page that generates an MS Access query and creates a table on a webpage. This code generates the field1 value on the original table.
Code:
If Request.querystring("mode") = "table1" then userID = Clng(Session("userID"))
     Set rsViewProfile = Server.CreateObject("ADODB.Recordset")
...