reading table data into textbox

does anyone know how this is really done, cause i cant seem to hold the values for an update

 

Val,

Here's the code I used in my World Recipe.

Check out World Recipe, you'll get some ideas by looking at the code


'Check which action were selected, edit a recipe or delete a recipe
strSQL = 'SELECT * FROM Recipes WHERE id=' & Request.QueryString('id')

DataBase_Connect(strSQL)
objDataReader.Read()

'This will be the value to be populated into the textboxes
Name.text = objDataReader('Name')
Author.text = objDataReader('Author')
Hits.text = objDataReader('Hits')
Ingredients.text = objDataReader('Ingredients')
Instructions.text = objDataReader('Instructions')

DataBase_Disconnect()