On a form, I have a subform that requeries a table based on the criteria entered in by the user. The table this query is running through is quite large, and in some instances, could return thousands of records.
Rather than having the user sit there for 2 hrs and wait, is there a way to stop the query from running? A command button that can abort the query and allow the user to enter in different criteria?
Is ctrl + break the solution? If so, is there a way to code that keyboard shortcut to a command button?
Rather than having the user sit there for 2 hrs and wait, is there a way to stop the query from running? A command button that can abort the query and allow the user to enter in different criteria?
Is ctrl + break the solution? If so, is there a way to code that keyboard shortcut to a command button?