Error on cancelling a requery button

[Uvuriel03]

I have a form that I can search for parts in. It's based off of a query that asks you for a part name, then brings up all records with matching part names.

I have a button that says "New Search" with a Requery macro behind it. The problem is that when I hit "Cancel" on the button, I get an Action Failed box.

Action Failed
Macro Name: New Search
Condition: True
Action Name: Requery
Arguments: [blank]
​

Any ideas on what to do? I suspect I just need to be able to stop the macro if the query is canceled, but I don't know how best to go about doing this.

 

[KenHigg]

So do you have a text box on the form that you type the part name in and the query that the form is based on uses that text box as a parameter?

 

[Uvuriel03]

Nope, no text box. Just the parameter from the query that pops up before the actual form opens, and then the form opens to display the matching records. Then, I'd like to (hypothetically) be able to click on the "New Search" button to look for a different part than the one you initially typed in.

 

[KenHigg]

There are numerous ways to approach this. I think if you put the requery in code instead of using a macro you'll loose the Action Failed thing.

 

[Uvuriel03]

I don't know code very well... Do you have a reference site, or maybe just the code I'll need itself?

Thank you!!

 

[KenHigg]

Something like:

me.requery

 

[Uvuriel03]

If I have this for the code:

Private Sub New_Search_Click()
Me.Requery
End Sub

I get this as an error:

Run-time error '3021':
No current record.

 

[KenHigg]

Sorry to bail on you but it's quitting time. Maybe someone else can jump it?

 

[Uvuriel03]

Anybody else have any input? I'm still stuck on this...

Thanks!