(3426) This Action was Cancelled by an Associated Object

[jcarroll]

Platform: Access 2000

Hi,
I am having trouble correcting an error that occurs when I issue the addnew command on a dynaset type recordset. This recordset is set to the .recordset property of a bound form.

-----------------------------------------------------------
Dim rstStatus As Recordset

Set rstStatus = frmFormAny!sfmPSNLine.Form.Recordset

With rstStatus

.AddNew '### Error 3426: This Action Was Cancelled By
'An Associated Object ###

!IssueID = lngForeignID
!EntryDate = Date
!User = DBEngine.Workspaces(cintCountStart).UserName
!Description = "Status Changed to " & strStatusHold & _
". Comment: " & strStatComm
!Enabled = False

.Update

End With

Set rstStatus = Nothing
-----------------------------------------------------------

notes: - both BOF and EOF are false on my recordset
- requerying the recordset does not make a
difference
- the current record is not null as per (or atleast
as I can see, therefore the knowledge base
article "PRB This action was cancelled by an
Associated Object.(3426)" does not seem to apply.

Has anyone seen this error before, any help would be greatly appreciated,
Justin

 

[LScharf]

Justin,

Apparently it's a known bug of sorts that has a simple workaround: you have to use the Edit method somewhere in there prior to Update.

Read more at

http://support.microsoft.com/default.aspx?scid=kb;EN-US;140309.

Lauri