Not getting results

[Ruegen]

I have in the listbox's rowsource query field

Completed: IIf(([tblBookings]![ShowTime1st]<>[tblBookings]![TimeProposed1st]) Or ([tblBookings]![ShowTime2nd]<>[tblBookings]![TimeProposed2nd]) Or ([tblBookings]![ShowTime3rd]<>[tblBookings]![TimeProposed3rd]) Or ([tblBookings]![ShowTime4th]<>[tblBookings]![TimeProposed4th]) Or ([tblBookings]![ShowTime5th]<>[tblBookings]![TimeProposed5th]) Or ([tblBookings]![BookingDate]<>[tblBookings]![DateProposed]),0,1)

if gives me a 1 or 0

instead of asking for either 1 or 0 I as a criteria I have

forms!formname!Text_Filter



now if forms!formname!Text_Filter is either 1 or 0 it filters nice however if I want to show both I figure I should show null

so nz(forms!formname!Text_Filter,1 OR 0) should work (I tried AND too) however I don't get the results or even correctly

any suggestions? I have tried an if statement - same result

[Ruegen]

fixed

using

Completed: IIf(IsNull([forms]![frmUpdateProposed]![Text_FilterCompleted]),0,IIf(([tblBookings]![ShowTime1st]<>[tblBookings]![TimeProposed1st]) Or ([tblBookings]![ShowTime2nd]<>[tblBookings]![TimeProposed2nd]) Or ([tblBookings]![ShowTime3rd]<>[tblBookings]![TimeProposed3rd]) Or ([tblBookings]![ShowTime4th]<>[tblBookings]![TimeProposed4th]) Or ([tblBookings]![ShowTime5th]<>[tblBookings]![TimeProposed5th]) Or ([tblBookings]![BookingDate]<>[tblBookings]![DateProposed]),0,1))

and

nz([forms]![frmUpdateProposed]![Text_FilterCompleted]),0) as the criteria