How to update a field??

I have a program that browses an Access 2000 table with an ADO connection in VB 6. I want to add functionality so the user can click on a row to pop open an editing form, and then I want to update the table with their changes after I validate them.

I have the editing form opening just fine.

Can you tell me what I need to do to update the fields in the database table, without screwing other rows up? Failsafe, time-tested method preferred.

Even more helpful, can you suggest a book or other hopefully concise reference I can use to learn all about VB ADO database programming?

Thanks - Tom

You could use an Action Query like

VB Code:

UPDATE Table SET FieldName='data' WHERE FieldName='Criteria'

Quote:

---

Originally Posted by dee-u

You could use an Action Query like

VB Code:

UPDATE Table SET FieldName='data' WHERE FieldName='Criteria'

---

For this to be failsafe though you need a primary key in the table. Say it is a field called ID, and you have two visible text boxes, txtOne and TxtTwo for displaying/editing the fields FieldOne and FieldTwo and one other (locked and probably invisible) called txtID for displaying the ID field. You could then use:
ADOConnection.Execute("UPDATE YourTable SET FieldOne = '" & txtOne & "', FieldTwo = '" & txtTwo & "' WHERE ID = " & txtID)

This is assuming that the two editable fields are text fields and the ID is numeric (autonumber is the easiest).