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?

 

[Uncle Gizmo]

This isn't a direct answer to your question, but I think it's near enough to at least offer you some inspiration...

Combo Filter < All> or Some

Combo Filter < All> or Some - Nifty Access

Combo Filtering You can set this up yourself by following the instructions below, or you can study the example file which can be downloaded from the Nifty Digital downloads site for a few dollars.. will normally appear as the first entry in your list because the angle bracket puts it at the...

www.niftyaccess.com

 

[plog]

Can you post the SQL you are using?