Add Item to combobox problem!

[Avatarp]

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?

[texas]

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

[Avatarp]

http://www.vbforums.com/showthread.php?s=&threadid=267599