Findfirst runtime error 3437 and 3426

[AndreAraujo]

Hi,
in have a combo box that is used to find the record that is displaid in the form, in the afterupdate event of that combo i get the error runtime error "3437 Database has been placed in a state by User ..." and some times the error "3426 This Action was Cancelled by an Associated Object".
this is the code im using:
Private Sub CmbPesquisa_AfterUpdate()
Me.Recordset.FindFirst ("codprojecto=" & Val (Me.CmbPesquisa.Column(0)))
Response = acDataErrContinue
end sub

Thanks

 

[DonQuichote]

I hope you mean

Me.RecordsetClone

. Otherwise, you are navigating the current form. When you have found the record, you can set the form's bookmark to the recordsetclone's bookmark.

Best regards

 

[AndreAraujo]

Thanks that fixed the problem.