Add "ALL" to Combo Box

[JimFlood2424]

Have a popup form to select a company, works good, want to add "ALL" to select every company in one report.
This is the Combo Box Row Source: SELECT [qry_TransByContractor].[CoAbbr] FROM qry_TransByContractor ORDER BY [CoAbbr];

I have tried several versions of Union Select of adding the "ALL", but each adds "ALL" but with no results, been searching on line and tried several.
Any suggestions?

 

[plog]

Can you post the SQL you are using?