I have a search form, that when a user clicks on a button it runs a query and displays the results in form view.
I put a macro on the form results that if there where no records to display a message "no records" and stop. But it shows the message you click OK and it still shows a form with no records in it.
What do I need to add to the macro to stop it opening the form and just send the user back to the search page