Unanswered: OpenForm Method was Cancelled promblem.
I am coding in access 97. I am a newbie to coding the front side in access. My problem is that I have a form name frmSearch. This form is bound to a query that uses a prompt in the criteria area. So when frmSearch is called the prompt is displayed. I have a button on my main form that when it is clicked the frmSearch form is opened. Thus displaying the prompt. If the user clicks cancel on the prompt I receive this message stating that the "OpenForm method was cancelled". How do I avoid getting this message. When cancelling the prompt.
Select Case Err.Number
' you get here when the openform method was canceled.
MsgBox Err.Description, vbCritical, "Error: " & Err.Number
Of course, you can develop more sophisticated error handler. But this simple is enough in many cases.