Selecting "ALL" items from a Combo Box

[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 teh
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
******

[Bob Quintal]

"to*******@yaho o.ca" <to*******@yaho o.ca> wrote in
news:11******** **************@ l41g2000cwc.goo glegroups.com:

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 teh 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
******

You'll need to create a union query based on your your current
row source. You must do this from the VIEW SQL mode of the query
builder.

Select " << ALL >>" as SECTIONCODE from SECTIONCODES UNION Select
SECTIONCODE from SECTIONCODES ;

The number and names of fields added must match in the two select
statements.

A more difficult question is how to process the " << ALL >> "
option when you select it.
--
Bob Quintal

PA is y I've altered my email address.

[pietlinden]

You mean like this?
http://www.mvps.org/access/forms/frm0043.htm

[tobhamlet]

Many thanks to both Bob and Pietlin

Marcus
*********