all i want is change all the record in my table if the pcarrier="Credit" but my problem is only one data have been changes. .
Set rs = New ADODB.Recordset rs.Open "Select * from Soldto where cno='" & Combo1.Text & "'", cn, adOpenKeyset, adLockPessimistic If rs!pcarrier = "Credit" Then Do Until rs.EOF rs!pcarrier = "Paid" rs.MoveNext rs.Update Loop End If
help thanks. .