I built a database to track specific items we receive. The search form in it works off a SQL query using NULL so everything is already a wildcard search. The search itself works perfectly, my issue is when you open the form, all the records show up. For the moment this is okay, but once we get into the thousands...

I did some googling to try to figure out how to make the search results empty when it opens. It was suggested to set the RecordSource using the OnClick when you hit the search button, leaving the form's default RecordSource blank. I did this, and it worked... until I closed the database and opened it again.

The code I'm using OnClick is RecordSource = "qrySearch"
The error I get is "Return without GoSub"

Now, if all I do is just open the VBA window and close it without changing anything, it starts working again. I can't ask my coworkers do that, so looking for a solution. I feel like I've missed something obvious here. Any help would be appreciated, thank you.