Add "ALL" to Combo Box

[JimFlood7898]

Been trying to add "ALL" to a combo box that opens a report from query.

Just can get it to work, been trying several links that I found on line.
This is my combo Row Source: SELECT [qry_TransByContractor].[Project_ID], [qry_TransByContractor].[CoAbbr] FROM [qry_TransByContractor] ORDER BY [CoAbbr];

[June7]

Use a UNION query. However, will need VBA code to deal with the "ALL" option. Review http://allenbrowne.com/ser-62.html

SELECT [qry_TransByContractor].[Project_ID], [qry_TransByContractor].[CoAbbr] FROM [qry_TransByContractor] ORDER BY [CoAbbr]
UNION SELECT 0; "_ALL" FROM qry_TransByContractor;