I am trying to edit a record in a database. I have used a radio button to select the record i want to edit and the "ID" is kept as a variable. I then go to another form and create a recordset belonging only to the variable record. If I response.write variable it puts the ID number on the form. Why does my line of code below not work.
set RS = Conn.execute("Select * from head_office where ID like '" & searchtext & " ' ")

Also how can i get the recordset when it has found it to go to text boxes ready for altering.

I am reaaly stuck here. Please help