howto: UPDATE single field

Results 1 to 2 of 2

Thread: howto: UPDATE single field

  1. #1
    D.c Guest

    Default howto: UPDATE single field

    hi guys,<BR><BR>i would like to know if it is possible to update only a single field in a record.<BR><BR>would i do this the same way i update all the fields in a record.<BR><BR>i have a button (submit) and when a user clicks on it, it changes a "status" field to the number 2 instead of one.<BR><BR>What is the easiest way to do this? :))<BR><BR>Thanks<BR>D.C

  2. #2 Guest

    Default RE: howto: UPDATE single field

    refer to my reply to the previous question <BR><BR>to see how to open and navigate a recordset.<BR><BR>assuming you have moved to the target record<BR><BR>rs("Status") = request.form("Status")<BR>rs.update<BR><BR>this will update only the field, Status with the formfield Status

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts