Formula

[johnbird1988]

Does any one know what this formula does not work in the form query builder thank you

IIf([forms]![Candidate_TABLE].[checkbox11]=True,([Candidate_TABLE].[Current Status])<>"closed","*")

 

[Montez659]

The second half of that expression starting with:

([Candidate_TABLE].[Current Status])<>"closed","*")

is supposed to be the result if false section, but it looks like you are maybe trying to do two IIF's here, in which case

IIF([Candidate_TABLE].[Current Status])<>"closed","*"))

would be more appropriate.

Let me know if you are trying to check one thing with the IIF or two things.