Start with blank search screen

[NKK]

I have a search form with 4 unbound controls that pass parameters to a query
which is the record source for a a listbox on the same form. It is working
beautifully (thanks again to this site!) but, when I open the form, I would
like for the listbox to be empty; currently all records are displayed. Since
I am still in development, this is not a problem but I do perceive it to be a
problem once this app goes into "production". So, is there a way to tell
access not to run the query using the on open event?

 

[tkelley via AccessMonster.com]

Clear the recordsource line in the properties of the listbox in design view,
then save and close. It should default to that every time.

If not, just put it in your OnOpen event of the form:

me.listbox.recordsource = ""