Add Item to combobox problem!

Access Question

I have a form that is used to filter another form. The combobox on the list has it's rowsource property to the query that runs the main form. I want to have the first item in the combobox to be "Show All" and the rest of the options from the rowsource listed after this option.

Any ideas?

the only thing i could get to work when i had to do this is create a new query to show all the results and reset the record source....

http://www.vbforums.com/showthread.p...hreadid=267599