Add item "All" to listbox

[Ganesh7299]

Dear Experts,



I just started with access and seeking for the help on lot of problems, below is the one of them.

Have created dynamic listbox, means list items are getting updated based on other listbox selection, to update listbox i have created query and linked the same with listbox row source.

Now i would like to add list item called "All" on top in the item list, which is not exist in the query results.

Any help highly appreciated . . .

Thanks,
Ganesh

[pbaldy]

See if this works for you:

http://access.mvps.org/access/forms/frm0043.htm

[amrut]

Post the SQL of your list box. Probably, a UNION query may be able to achieve what you require.

[amrut]

Please ignore my earlier post. I think you need to use VBA to achieve what you require.( Changing the list box row source to value list and loading it at runtime)

[Ganesh7299]

UNION query works fine