IIF (I want it to cancel or do nothing)

[sps2]

Hello all, first time on the fourm.

IIf(IsNull([forms]![DateSelectionWO]![OrganizationCombo]),"",[forms]![DateSelectionWO]![OrganizationCombo])

This is checking a form to see if a selection was made in a combo box "OrganizationCombo". If so then the report show the records matching the selection. What I would like, is if no selection were made, the report would show all records. With a selection made it works fine, when no selection is made the report shows no records.

Thanks for any help.

 

[Kiwiman]

Howzit

Another way is to include "ALL" in your combobox and make the "*" as the default selection.

As the all option is default, it will run the report for all the data, unless the user specifically changes to a specific subset.

Check out the link below, re putting "ALL" in your combobox

http://www.mvps.org/access/forms/frm0043.htm

 

[sps2]

Thank you both for responding. I will work on these and let you know. Thanks again.