Hello, in several forms i have a NEXT, PREVIOUS and SAVE command buttons which were working perfectly...no errors showing...nothi ng!!! i had to convert my DB to 2003 so i could create the .mde. I did the conversion and now my forms give me a run-time error 2105 or 2499 every time i reach the first/last record and try to go one more previous/next record. Im new with access and dont want any fancy error handler i just need to AVOID the error and be able to continue working.
What can i do??? the following is the code for a NEXT button im using.
Please help
What can i do??? the following is the code for a NEXT button im using.
Please help
Code:
Private Sub GO_TO_NEXT_Click()
On Error GoTo Err_GO_TO_NEXT_Click
[B] DoCmd.GoToRecord , , acNext[/B]
Me.Engineering_subform.Requery
Me.Refresh
Exit_GO_TO_NEXT_Click:
Exit Sub
Err_GO_TO_NEXT_Click:
Resume Exit_GO_TO_NEXT_Click
End Sub
Comment