The ADDNEW method not working

[JohnBates]

Hi VB people -

Using VB 6, I have a form which allows add/update/delete, with text boxes as data-bound controls via the ADO data control.

The problem is with Adding a new record :

*********************************************************
'The following code results in the new record getting written OVER the existing rec that was displayed before entering add mode. Also inserts an EMPTY row!
********************************************************

datPrimaryRS.Recordset.AddNew
datPrimaryRS.Recordset!ReaCode = txtCode
datPrimaryRS.Recordset!ReaDesc = txtDesc
datPrimaryRS.Recordset.Update

Thanks for any help. John

 

[jackg]

declare the recordset with these properties

.CursorType = adOpenKeyset
.LockType = adLockOptimistic

 

[1127]

adOpenDynamic
adLockBatchOptimistic

and dont use the Update use UpdateBatch

 

[agalarzapr]

try to stay away from data controls and do it by coding

 

[tigreeuropeo]

I agree with agalarzapr. Data controls are a nightmare...