Forms :: Enter Parameter Box For Every Filter

I have a form which contains a listbox sourced from a query and several text boxes where the user can enter filters for the query. The query has references back to the form for the criteria, i.e. the filter for "Company Name" is handled in the query criteria as

Code:
Like "*" & [Forms]![HooversProspects]![SearchText] & "*"

When i exit this form in my un-compiled version it does not pop up an "Enter Parameter" box, however, when i exit this form from the compiled version it pop ups the "Enter Parameter" box for every filter I have.

How i can fix this? Perhaps change the rowsource on the query to null upon exit?