"to*******@yahoo.ca" <to*******@yahoo.ca> wrote in
news:11**********************@l41g2000cwc.googlegr oups.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.