How do I return all records in a Query when user types "ALL" in a combo box?
IIf([forms]![Form2]![Combo18]="ALL",([PASSTHROUGH CUSTOMER LIST].[NAGRP])="*",[forms]![Form2]![Combo18])
If the user types "ALL" in Combo18 the list box returns nothing.
Otherwise the list box is returning the specific selection in the combo.
Thank you!!