Combo Box Selection Issue

[tobhamlet]

If one is using a query as a Row Source on a Form, is there a way to
set up a blank space, or to insert the word "ALL" in a combo box that
represents ALL combo box row items.


The scenario is as follows. I have two combo boxes. One for
COURSECODEs and one for SECTIONCODEs. I select a COURSECODE from the
1st combo box. Then, from the 2nd combo box I want to select ALL
SECTIONCODEs (associated with the COURSECODE).


This is for MS Access 2002.


Many thanks in advance.


Marcus
******

 

[[MVP] S.Clark]

You can UNION it into the query.

SELECT ID, Name from tablename

UNION

SELECT 0, 'ALL' from tablename