Hi,

I create combo list that has a list of sports. The combo list table
has

- hockey
- baseball
- Bowling
- Tennis

I don't want to add "all sports" to combo list table. Is there a
way
to add "all sports" to combo list on the form instead of table.
My query has a field called SPORT. If I want to select "ALL sports"
from the form
then I get All sport names.

Your help would be much appreciated

Thanks

On Sat, 1 May 2010 08:24:13 -0700 (PDT), "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

Yes. I'm guessing your combobox currently has a RowSource that is the
table name. Change that to a query name instead. Create a new query,
switch to SQL view (that's the only view in which you can write a
union query), and write something like this:
select -1, "All Sports" from tblSports
union all
select SportID, SportName from tblSports

-Tom.
Microsoft Access MVP


>Hi,
>
>I create combo list that has a list of sports. The combo list table
>has
>
>- hockey
>- baseball
>- Bowling
>- Tennis
>
>I don't want to add "all sports" to combo list table. Is there a
>way
>to add "all sports" to combo list on the form instead of table.
>My query has a field called SPORT. If I want to select "ALL sports"
>from the form
> then I get All sport names.
>
>Your help would be much appreciated
>
>Thanks