Handling Error 2001 on Cancel - MS Access 2016

1
votes

I have a form that I am requerying on the click of a button using 

DoCmd.Requery

This works and I am able to requery the form based on the criteria I specified in my query table. However, if I cancel the requery, rather than click OK, I get an error (2001). How can I have the form remain as is if the user cancels?

Thanks!

1
ms-accessvbarefreshms-access-2016

1 Answers

1
votes

Does the following work?

  On Error Resume Next
  DoCmd.Requery
  On Error GoTo 0