Enter Parameter Value Issue (1 Viewer)

[BrotherBook]

Hi-

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

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.

Any idea how i can fix this? Perhaps change the rowsource on the query to null upon exit?

Thanks,
Mike

 

[billmeye]

Is it possible you have an Me.ListBox.requery firing on exit or is something else dependent upon this Listbox that is trying to pull data upon exit?

 

[BrotherBook]

Thanks for the reply. Several of my filters had requeries in the OnExit properties which seemed to be causing the problem. I changed these to fire on AfterUpdate, and I also pass a new RowSource when they click my "Close" button which removes all the filters.

This fixed the problem. Thanks for your help.

 

[billmeye]

Glad you solved your problem.