problem updating from a datagrid
-
Dim RS As AdodB.Recordset Set RS = New AdodB.Recordset Dim intCurrentRecord As Integer Dim iOrderNo As String Dim strProductCode As String Dim strDesc As String Dim iQuantity As Integer Dim iPrice As Integer iOrderNo = txtOrderNo.Text strProductCode = Adodc3.RS("ProductCode") strDesc = Adodc3.RS("ProductDesc") iQuantity = Adodc3.RS("Quantity") iPrice = Adodc3.RS("Price") With intCurrentRecord Dim editSQL As String editSQL = "update OrderDetail set ProductCode = '" & strProductCode & "', ProductDesc = '" & strDesc & "', Quantity = " & iQuantity & ", Price = " & iPrice & "" Set RS = Conn.Execute(editSQL) End With the (intended) purpose of the above code is that when the user pressed the edit button, having changed the details of the current record in the datagrid, that the SQL statement would execute the update. however, i am not referring to this current record properly, it is not recognising it, throwing an error of "method or data member not found", what can i do to fix this? thank you!