Query Criteria Error

[birth19]

Hi All,



I have a form with 4 combo boxes so I can search a certain criteria.

I have research this and have been using this

[Forms]![Search]![Combo11] Or [Forms]![Search]![Combo11] Is Null

This work absolutely fine for a few times.

Then all of a sudden it got buggy and change all the criteria lines and looked horrible.

Please tell me there is something simple that I have done wrong!

Please see attachment images to understand.

[June7]

The criteria doesn't make sense. It translates to: Find records where ([Week Number] equals Combo13 or [Week Number] equals Combo13 is null) and ([Project Name] equals Combo11 or [Project Name] equals Combo11 is null)

What you might be trying to do is: Find records where ([Week Number] equals Combo13 or [Week Number] is null) and ([Project Name] equals Combo11 or [Project Name] is null)

Are these two fields allowed to be blank (no data)?

Review http://datapigtechnologies.com/flash...tomfilter.html

[AndreasPanayiotou]

Hello birth19,
I am familiar with your issue , its not your fault but access here is the solution .
As i understand this is a search query .
What you should do i recomment that you manual write the query inside the SQL Query , then save it .
These changes when your in the sql query mode , then go to the design view and then back to the SQL Query Mode .
Or if your in the sql query mode then Design view and you run the query from the design view .
I am not sure why and how but access mess it up. So be sure when your changing from SQL Query to Design view dont save the changes and your code will be OK .