error 3021 No current Record

Question

Hi

if my db rund out of data then i get the standard ,error 3021 No current Record, end and debug.

i want instead a message box where i can make sure the user knows theres no data but have a button to take into another form.

is there a way to do that please

thanksyou

Answer 1

Yes, its called Error Trapping. I suggest searching on Access VB Error Trapping to find more details. You didn't give us enough info to give more than a suggestion.

It might look like this

ON ERROR GOTO ErrorHandler 'This line goes near the top of your code

:ErrorHandler

Select Case Err.Number

 Case 3021

       MsgBox "your message"

 Case Else

      MsgBox Err.Number & "-" & Err.Description

End Case