General discussion
February 8, 2005 at 09:04 AM
nnlogistics

Error 3426 in Access

by nnlogistics . Updated 21 years, 7 months ago

I’m fairly new to coding. I’m getting a run time error 3426 – This action was cancelled by an associated object. Debug highlites the addnew line. Strange though, I’m not getting it at the system I develope at(win 2k and office xp), when I bring it home (Win xp and office 2k) I get the error. I checked the refereces and they are the same. I put together another system(Win2k and office 2k) and it also fails the same way.

Private Sub txtDateReturnedtoVHO_AfterUpdate()
‘Write additional Record to tblVendorRepair

Me.RecordsetClone.AddNew

Me.RecordsetClone!fldOrderDetailID = Mid(Me.txtRMANumber, 5)
Me.RecordsetClone!fldDateToVHO = txtDateReturnedtoVHO
Me.RecordsetClone!fldRMANumber = txtRMANumber
Me.RecordsetClone!fldReasonForReturn = txtReasonForReturn
Me.RecordsetClone!fldNCWarranty = -1

Me.RecordsetClone.Update

MsgBox (“Record Written To TblVendorRepair”)
—
Thanks for any assistance

This discussion is locked

All Comments