[AccessD] A2k - BeforeUpdate Error 2105!!! PLease help!

S D accessd667 at yahoo.com
Fri Mar 5 05:06:58 CST 2004


Hi group,
 
I'm using Access 2000 and I get an error 2105 when Access "leaves" the BeforeUpdate event. So i DO NOT have an error when I'm on the line END SUB (see code below). 

I've searched the web but all I fount was this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;128195&Product=acc97
"--------------------------------------------------------------------------------------------------------
When you perform an action in the BeforeUpdate event, you receive the following error messages, even if you have canceled the event. 

In Microsoft Access 7.0 and 97: 


- Runtime error '2105'
You can't go to the specified record 

--------------------------------------------------------------------------------------------------------"
 
But this is regarding an Access97 database. Could it be that the database was migrated from A97 to Access2000?? If so what can I do about it?
 
Once again the code is OK. There are no errors!
 
Any ideas?
 
TIA
 
Sander
 

Private Sub Form_BeforeUpdate(Cancel As Integer)



If IsChangeOK Then

' MsgBox "form_beforeupdate"

frmKAM_ProcessKey (vbKeyPageDown)

Else

Cancel = True

End If



End Sub



---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.


More information about the AccessD mailing list