CBO List

[learning_codes]

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

 

[Tom van Stiphout]

On Sat, 1 May 2010 08:24:13 -0700 (PDT), "(e-mail address removed)"

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