SELECT
auditor_calc_list.auditor
From auditor_calc_list
UNION
Select
Null as AllChoice ,
"(All)" as Bogus
FROM auditor_calc_list;

There is one field in the top value, and two in the bottom,
which is exactly what the error message says.

try:
SELECT
auditor_calc_list.auditor as Hidden
auditor_calc_list.auditor AS Visible
From auditor_calc_list
UNION
Select
Null as AllChoice ,
"(All)" as Bogus
FROM auditor_calc_list;

then set the combobox for 2 columns, and make the first one Zero
width.

Try this:

SELECT Auditor FROM Auditor_Calc_List
UNION
SELECT "(All)" as Bogus FROM Auditor_Calc_List

Fred Zuckerman

Per Mark:

A technique that's worked well for me in avoiding errors like the one in the SQL
above:
------------------------------------------------------------------
1) Create an MS Access query for the first part of the union.
  Call it qryAuditorDropdown (SQL1).

2) Create an MS Access query for the second part of the union.
  Call it qryAuditorDropdown (SQL2).

3) Test each query individually and confirm that it does what
  you want it to do.

4) Create a third query: qryAuditorDropdown.

5) In SQL view, just paste in the SQL from the first two
  queries with a UNION in-between.

6) Test it to see if it does what you want.   Here's where
  JET will tell you about the mismatch in number of fields
  returned by each query.

7) If it doesn't do what you want (i.e. there's a sequencing
  issue)  rename qryAuditorDropdown to qryAuditorDropdown1,
  create qryAuditorDropdown2 based on ...1 and add sorting
  as needed.
--------------------------------------------------------------------

In the end, you wind up with 3 or 4 queries instead of none, but
the functionality is encapsulated and labeled for everybody to see
and it's modularized for testing.