IIF query using OR operators not working

[Reigncloud]

I'm trying to run the following as criteria in an MS access query. Basically what I want to do is:

• If checkbox = True then all records, including those with blank or Null fields are shown (the default value in my form's combo box [combo9] is "*")
• If checkbox = False then only records that match the value in Combo9 are shown

My current expression doesn't give any errors, but also doesn't produce any results! The TRUE and FALSE halves of the expression work fine on their own, but don't work when combined into the iif expression.

Like IIf([Forms]![F_leg_reg]![Check25]=True,Like [Forms]![F_leg_reg]![Combo9] Or "" Or Is Null,Like [Forms]![F_leg_reg]![Combo9])



Can someone please tell me what I'm doing wrong here? Thanks in advance.

[Aragan]

Like IIf([Forms]![F_leg_reg]![Check25]=True,Like [Forms]![F_leg_reg]![Combo9] Or "" Or Is Null,Like [Forms]![F_leg_reg]![Combo9])

Can someone please tell me what I'm doing wrong here? Thanks in advance.

U r making a mistake in the Iif arguments, it should be (expr, value if true, value if false)

[Reigncloud]

Yes, I know it's a mistake. Any specific help to rectify it would be appreicated!

[orange]

Please show the entire code.

[Aragan]

Be more specific... if teh field is true then all the records are shown... but where??? in a subform?? in a query called when a button is pressed?

[orange]

Show the sql for the query.