Checkbox for incomplete tasks only

[WhiskyLima]

Hey all! Im working on a basic filter in a task list. Firstly please forgive my strange naming conventions, I have had no formal training in access so I just make it up as I go along.

Anyway, what im after is a check box called [onlyComplete] which is located at the top of a task list called [All Tasks]. The idea is that 'After Update' on this checkbox, the Me.Requery kicks in. The criteria for the query is based on the 'complete' field and looks like this:

IIf([Forms]![All Tasks]![onlyComplete]=-1,0,<1)

Now this is supposed to display either the incomplete tasks only or all the tasks, however it is either displaying the incomplete or complete but not both.]

Im sure its something stupid im missing here, like I say Im quite new to this and I have only a basic understanding of the coding etc.

Any help is as always appreciated guys! Many thanks in advance

[June7]

This is criteria in query? Suggest that you don't use dynamic parameterized query - I never do (I don't think this conditional criteria can be made to work). Use code to set the Filter and FilterOn properties of form, I use only VBA, like:

Me.FilterOn = False
If Me.onlyComplete = True Then
Me.Filter = "Complete=0"
Me.FilterOn = True
End If

[WhiskyLima]

That works like a charm, thank you very much! I can see how this Filter code could be very useful to me actually because Im thinking about using a few filters on the same form and using a query to organise all the filters would have been a nightmare, this makes much more sense!