Add "ALL" to a list box

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

Angel_G

How can I add a "ALL" option in a list box that is bound to a table without
having to add ALL as an Item on the table.
Any help is much appreciated.
 
Change the RowSource SQL of the List Box to something along
the following lines

SELECT "ALL" FROM {yourTable}
UNION
SELECT {yourColumn} FROM {yourTable}

Hope That Helps
Gerald Stanley MCSD
 
I am sorry but Actually it is a combo box that when pulled down the first
Item will be "All" even dough "All" is not part of the Items in any table.
Sorry about the confusion.
 
Angel_G said:
I am sorry but Actually it is a combo box that when pulled down the first
Item will be "All" even dough "All" is not part of the Items in any table.
Sorry about the confusion.
Click to expand...

I don't see confusion (yet); you don't want to *save* the All option,
but what *do* you want with it?

Gerald's answer is valid for the selection part; and you didn't include
a reaction part; specify!
 
I wasn't confused until I saw your reply. The SQL I
supplied will achieve what you want, namely that the first
item in the list is "ALL" followed by the rest of your
selections from your table.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top