Originally Posted by ryan311

i have error to my code in the bold word!

Help with Code Tags

(Toggle Plain Text)

Set rs = New ADODB.Recordset
Set rs1 = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
rs.Open "Select * from temp where pcode='" & txtEdit.Text & "'", cn, adOpenKeyset, adLockPessimistic
rs1.Open "Select * from product where brandname='" & txtEdit.Text & "'", cn, adOpenKeyset, adLockPessimistic
rs2.Open "Select * from Sold", cn, adOpenKeyset, adLockPessimistic
If rs1.RecordCount > 0 Then
rs1.Fields![quantity] = Val(rs1.Fields![quantity]) + Val(rs2.Fields![quantity])
rs1.Update
End If
If rs.RecordCount > 0 Then
Label7.Caption = Format(Label7.Caption - rs!price * rs!quantity, "00.00")
rs.delete
rs.Requery
MsgBox "Product Successfully Delete", vbInformation
Call grdloader
txtEdit.Visible = False
End If

Set rs = New ADODB.Recordset Set rs1 = New ADODB.Recordset Set rs2 = New ADODB.Recordset rs.Open "Select * from temp where pcode='" & txtEdit.Text & "'", cn, adOpenKeyset, adLockPessimistic rs1.Open "Select * from product where brandname='" & txtEdit.Text & "'", cn, adOpenKeyset, adLockPessimistic rs2.Open "Select * from Sold", cn, adOpenKeyset, adLockPessimistic If rs1.RecordCount > 0 Then rs1.Fields![quantity] = Val(rs1.Fields![quantity]) + Val(rs2.Fields![quantity]) rs1.Update End If If rs.RecordCount > 0 Then Label7.Caption = Format(Label7.Caption - rs!price * rs!quantity, "00.00") rs.delete rs.Requery MsgBox "Product Successfully Delete", vbInformation Call grdloader txtEdit.Visible = False End If

all i want is if the user delete the record then the quantity of the table in Sold must be + to the quantity table of product. .