Can i suppress Acess message ?

[samotek]

Is there any possibility to suppress a message box from Access ? I have a complicated but a good code that calculates the possibilities in the before update event, and if a condition is met, then it exits the sub.In short, if this condition is met, then after the exit sub I get the following message box:
Runtime error 2105 you cant go to the specified recod

END DEBUG

If I click on End, then the code is perfect,everything I cleared and I can begin anew.If only I could auppress the appearance of the message box.Can someody help me ?

 

[PHV]

And which code is highlighted when you click on DEBUG instead of END ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zion7]

Yes, As PHV is intimating, the message box is being evoked, because there is an error in your code.

To avoid the message, is very sinmple.

Private Sub xxxx_BeforeUpdate(Cancel As Integer)
On Error GoTo ErrMsg


...your code...

Exit Sub

ErrMsg:
If Err.Number = 2015 Then
Exit Sub
Else
MsgBox Err.Number & ": " & err.Description
End If
Exit Sub

BUT, YOU"RE NOT SOLVING THE PROBLEM, just avoiding it!

Consider PHV's suggestion.