I looked at your db. I could not make any changes to it--not sure why, but you must have some sort of exclusive setting.
In your query you have your fields pointing to a form named "searcform" but this form does not exist. You need to change your criteria to reflect the name of your seach form "Form1" or change the name of your search form.
Additionally, there is no code behind the Run button to open the query. You will need to put a DoCmd there to open it.
good luck with this.
Also, in your code for Clear the query, add this to your code "Me.requery" without the quote marks
Alan
Bookmarks