adding an "ALL" selection to my listbox

[kidrobot]

My list box values are populated by a linked table. So, I can't add any values to this table. I want to add a value that says "All" so when the user highlights "All" it will pull up everything. I have everything set in my code for this "All" selection, but now my only problem is that there is no "All" selection in the list box!

Also, the reason I can't just make my own table is because the linked table will contain updates and since I won't be working at this job forever no one can maintain a table that I make up. So if there is a way to add an "All" value on top of what I already have let me know!!

 

[Banana]

Did you even google? I know there's lot of examples about adding an "All" selection to a listbox out there.

 

[RuralGuy]

One way is with a UNION query. A control can not tell the difference between a table and a query.

 

[missinglinq]

In your RowSource place this SQL

SELECT YourField FROM YourTable
UNION SELECT "(All)" FROM YourTable;

 

[kidrobot]

Did you even google? I know there's lot of examples about adding an "All" selection to a listbox out there.

Yeah man, I googled "access list box All" and I was taken to a bunch of things that were irrelevant.

 

[Rabbie]

Yeah man, I googled "access list box All" and I was taken to a bunch of things that were irrelevant.

I tried "access listbox all" and first hit was http://www.mvps.org/access/forms/frm0043.htm which looks as if it might answer your question.

 

[kidrobot]

The problem was I didn't know what to look for. I didn't think a union query would solve this. For one I don't know what a union query is or does, but now I know.

 

[RuralGuy]

Relax everyone! We *all* started somewhere.

 

[Rabbie]

For one I don't know what a union query is or does, but now I know.

At least this forum is educational!