Too complex query error

[Gkirkup]

I have a quite simple query which dispays records EITHER if the priority level matches the control on a form, and the level is "CLOSED' OR the priority level on the form is "All' and the level is "CLOSED'. I get a formula too complex error. What can I do to eliminate this error?
Robert

SELECT TMHed.Priority, TMHed.TicketNumber, TMHed.TicketName, TMHed.DateTime
FROM TMHed
WHERE (((TMHed.Priority)=[Forms]![TMListClosedMain]![txtPriority]) AND ((TMHed.Level)="Closed")) OR (((TMHed.Level)="Closed") AND (([Forms]![TMListClosedMain]![txtPriority])="All"))
ORDER BY TMHed.TicketNumber DESC;

 

[spikepl]

If you put a lot of stuff together and the pile of stuff fails to perform as desired, then start over, but this time test each bit before you add it to the pile.