Add "ALL" to a list box

[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.

 

[Gerald Stanley]

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

 

[Angel_G]

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.

 

[Bas Cost Budde]

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.

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!

 

[Gerald Stanley]

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