Access Deleting a Query SQL

[michelleumich]

Hi all,
I am working with a multiple parameter search query. The form I am
using to conduct the search displays the results in a subform. I have
gone through and really combed through the SQL to make sure there are
no blatant spelling errors or incorrect references within the code.
Anyways when I open the form that it is attached to, I keep getting
the boxes described in this website http://allenbrowne.com/bug-13.html
.. The form is open, and I even changed names of fields in the table
in case SQL was choosing to be picky about what I named my fields. Is
there anything else that would cause this error that anyone is aware
of?
So, after I open my form and those boxes pop up, I will try to play
around with the form a little to see if it's just a 'startup error'.
If I hit the command button I set up to run the Query I will go back
to the SQL after closing the form and Access will have deleted it.
Does anybody know why this is happening? Is there anything I can do
to fix this? Here is my code just in case it will help:
SELECT [2007-08ScholarshipMaster2].*
FROM [2007-08ScholarshipMaster2]
WHERE ([2007-08ScholarshipMaster2].Name Like "*" & Forms!
QueryMultiValueSearchForm!txtFilterName & "*"
Or Forms!QueryMultiValueSearchForm!txtFilterName Is Null)
And (Forms!QueryMultiValueSearchForm!txtFilterUMID Is Null
Or [2007-08ScholarshipMasterLink].UMID=Forms!QueryMultiValueSearchForm!
txtFilterUMID)
And (Forms!QueryMultiValueSearchForm!txtProjectGrant Is Null
Or [2007-08ScholarshipMasterLink].PG=Forms!QueryMultiValueSearchForm!
txtProjectGrant)
And (Forms!QueryMultiValueSearchForm!txtStartDate Is Null
Or [2007-08ScholarshipMaster2].ScholarshipStart=Forms!
QueryMultiValueSearchForm!txtStartDate)
And (Forms!QueryMultiValueSearchForm!txtEndDate Is Null
Or [2007-08ScholarshipMaster2].ScholarshipEnd=Forms!
QueryMultiValueSearchForm!txtEndDate);