I have a list box on a form that filters a report.  It is set up so that if
nothing is chosen in the list box, the report prints all and if items are
chosen, then it just prints those items.

On the report header I have the items chosen in the list box.  The control
source has this in it:

      =enumrecord("PrintDialogInventoryFranchiseLBqry2")

This all works just fine.

But I want to make a slight change.  Instead of listing all items if nothing is
chosen in the listbox, I want it instead to just say "All" in that case.

I tried a thing like this:

=IIf([Forms]![InventoryDialogPrintfrm]![FranchiseChosen] Is
Null,"All",enumrecord("PrintDialogInventoryFranchiseLBqry2"))

or this:

=IIf(Len([InventoryDialogPrintfrm].[Forms]![FranchiseChosen])=0,"All",enum
record("PrintDialogInventoryFranchiseLBqry2"))

I even attempted to write code in the OnOpen of the report for the control
source of the text box, doing a If-Else statement.  But I can't seem to get it.

Any help would be greatly appreceiated.

The dialog Print form is: InventoryDialogPrintfrm
The Listbox is: FranchiseChosen
The Textbox on the report is: Franchisetxt
The query that holds the listbox items is: PrintDialogInventoryFranchiseLBqry2

Thanks again,

Matt

(This message has been repeated because I can't find my original post after I
choose all and keep on pressing the More button.  It just doesn't seem to get
through. This is the thrid attempt.)