snoopy92211
Technical User
Hello. I have a form with several comboboxes. This form will allow users to select whatever criteria they want and print a report using named criteria.
The reports are working fine until I decided that I wanted to add an <all> option in the combobox.
Here's my combobox, named ItemType. The rowsource type is table/query, the rowsource for the ItemType is
This code does not work. When I try to open this report, I get nothing. But -- when I select an individual item in my itemtype combobox, the report appears fine.
Please help!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
The reports are working fine until I decided that I wanted to add an <all> option in the combobox.
Here's my combobox, named ItemType. The rowsource type is table/query, the rowsource for the ItemType is
Code:
SELECT IRSItemType.ItemTypeID, IRSItemType.ItemType FROM IRSItemType UNION SELECT "*", "<All>" FROM irsitemtype order by irsitemtype.itemtype;
This code does not work. When I try to open this report, I get nothing. But -- when I select an individual item in my itemtype combobox, the report appears fine.
Please help!