Adding to an already populated Listbox

[Pikeboy]

I'm currently populating a listbox using the results of a query as its rowsource. However, I need to also ADD the entry of 'ALL' to this listbox for use later. I know the down and dirty way would be to add a record to my root table with 'ALL' in each of the fields where I might like to have this included in a listbox but what would be an approach I could use programatically with VBA? Thanks in advance.

 

[pbaldy]

A common method:

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