| re: Selecting "ALL" items from a Combo Box
"tobhamlet@yahoo.ca" <tobhamlet@yahoo.ca> wrote in
news:1110840602.182017.154250@l41g2000cwc.googlegr oups.com:
[color=blue]
> 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
> ******[/color]
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.
| 
