When I save a new record in my app all works well for the first new record. Any subsequent records I try to add give me this error:
update requires a valid updatecommand when passed datarow collection with modified rows
here is my code:
Private Sub SaveNewRecord()
Try
FurnacePartPoursBindingSou
rce.Curren
t("item") = Me.cboItems.Text
FurnacePartPoursBindingSou
rce.Curren
t("Entry Number") = NewKeyValue
FurnacePartPoursBindingSou
rce.Curren
t("Operato
r") = cboOperator.SelectedValue
Me.Validate()
Me.FurnacePartPoursBinding
Source.End
Edit()
If Me.PctDataSet.HasErrors Then
...
Exit Sub
Else
Me.FurnacePartPoursTableAd
apter.Upda
te(Me.PctD
ataSet.Fur
nacePartPo
urs) ' error occurs here
End If
end sub
Thanks, bmutch
Start Free Trial