Also, the order of field names must match the order of field values. lname = "Kobara" ` Show contents of buffer and get user input. If the number and order of fields and values do not match, an error occurs. str Message = "Edit in progress:" & vb Cr & _ " Original data = " & str Old First & " " & _ str Old Last & vb Cr & " Data in buffer = " & _ rst Employees! lname & vb Cr & vb Cr & _ "Use Update to replace the original data with " & _ "the buffered data in the Recordset?
Open str Cnn ' Open recordset with data from Employee table. If the object supports batch updating, then you can cache multiple changes to one or more records locally until you call the ADO Recordset Object Update Batch Method. " If Msg Box(str Message, vb Yes No) = vb Yes Then rst Employees. If you are editing the current record or adding a new record when you call the to save the changes. Dmoney's description is accurate, the record.set(values) command is not refreshing the grid although the store is correctly updated.If the user selects the row again from the grid or sorts from the column header, the modified field is marked as dirty. There are two buttons on the grid; they both increment the age of "Lisa", but the "Single Param" button uses the single-argument format for record.set(), while the "Double Param" uses the two-argument format.