Click to See Complete Forum and Search --> : VB DdataEnvironment


simonkwan
December 29th, 1999, 09:43 PM
Hi, I get an error of "could not locate the row ..." when I delete a row which just added, why ? But it can be deleted when i quit the program and then execute again.
Thank you !


private Sub Command1_Click()
DataEnvironment1.rscncustomer.AddNew
me.txtCUSTID = "123456"
me.txtCUSTNAME = "ABC company"
DataEnvironment1.rscncustomer.Update
DataEnvironment1.rscncustomer.Delete
End Sub

Muhammad Asad
December 29th, 1999, 11:50 PM
Check for the EOF or BOF property of the recordset. Either of them is true. This can be the error