Forms -->Report/Query

[ewong1]

I have a form that calls for a combination of combo boxes, date fields, check boxes to be filled in. I am using this form as a "user interface" for querying specific orders in my table tblOrderDetail through qryOrderDetail. The results will then be posted on report rptOrderDetail. I have all three working properly for the first instance of the query, but once another query is attempted, the conditional requirements are jacked up. The firsts query is now becomming a part of the requirements for future queries, and so on and so forth down the line. If I attempt a query, the fields I fill out for filtration become a part of the query itself.

I have attached a copy of what the sql looks like after I have attempted the query a couple of times(see code.txt in attatchment). Currently the original criteria for the query is as follows(same concept for each field):

forms!frmFindOrderDetail!intProgram OR
forms!frmFindOrderDetail!intProgram Is Null

I was using the is null case for the situation where no value is entered. Let me know if you see what I have done incorrectly. Thanks for your help!

 

[maxmangion]

since you are using the form just to pass parameters, make sure that your text boxes/combos in your form are unbound and not bounded to any field of a table/query.

 

[ewong1]

Already unbound fields

I looked into my form to double check your suggestion against my system, but the fields in my search form are not bound to a table or query.. Any other ideas?

 

[ewong1]

Found it! The query requires a "like" statement instead of a "where" statement. Thanks for your try!