Getting runtime error 2001 you canceled the previous operation

[Bluestreak1]

I am a beginner with access and I am trying to create a basic search. I am getting a “runtime error 2001 you canceled the previous operation” when I click the command button and then cancel the search. I used the code below for the on click event for the command button.

Private Sub Command225_Click()
DoCmd.OpenQuery "Issue_Search", acViewNormal
End Sub


The code I used in the query “Issue_Search” is below.

Like [forms]![searchform].[issue_search] & "*"

Also another question I have is after clicking the search button the pop up search box contains the code from referenced query. Does anyone know how to change the text for this pop up box? I am hoping someone can help me out here? TIA.

 

[Remou]

You can add error handling do trap the error. Can you explain the second bit again in more detail, please?