Is this possible?

[dlacloche]

Can I use one form with one submit button to INSERT a record into a table of a database and create a session variable from a hidden field in the same form?

[russell_g_1]

yes. this is pretty standard stuff. just do it like this.

'set the session variable like this
session("myvar") = request("myhiddenformfield")

'insert a record into a db
set conn = createobject("adodb.connection")
sql = "insert into (a,b,c) values ('a','b','c')"
conn.execute sql

put it all in the one asp page or sub or whatever and it'll work fine.