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.