Create the recordset then while it is open make the value of the textbox, or whatever you want, a value coming from the recordset.

Checkout http://www.w3schools.com/asp/default.asp