Allow Blank CBO to pull All Values to ListBox Not Working 1

[Fattire]

My users have 3 values from a combo box to chose from which is used to isolate the data they need to a listbox. I'd like them to have the ability to retrieve all data if the combo box is blank. How can i accomplish this?

I've tried using the 'Switch', 'IIF', and 'NZ' funtions in the crieria of the query populating the data, none worked, such as:

NZ([Forms]![FRM_MAIN]![CBO_BALANCE_STATUS],((([TBL_BALANCES].[BALANCE_STATUS])="Open" Or ([TBL_BALANCES].[BALANCE_STATUS])="Closed" Or ([TBL_BALANCES].[BALANCE_STATUS])="Closed UC")))

This code above does not error out - it just doesn't provide any data to the listbox.

Any help would be appreciated.

 

[PHV]

=[Forms]![FRM_MAIN]![CBO_BALANCE_STATUS] OR [Forms]![FRM_MAIN]![CBO_BALANCE_STATUS] IS NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Fattire]

PHV - That worked but only after I took out the default value - ty again.