I have a form that drives a query for a report. There is a combo box with three choices for a field to filter on. It works great, except that now that the user has seen it, he wants the combo to have an option for 'All'. I used a Union query to add 'All' as an option but now I don't know how to make the query work properly. The underlying query has [forms]![formname]![fieldname]. If they pick one of the three valid choices for the field it work fine but if they pick 'All' it doesn't. I understand why (none of the records contain the text 'all') but I don't know how to fix it. Is this possible?