I have a form that collects selection criteria for a report. One of the questions is to select an Instructor. I use a combobox with the rowsource set to the instructor table. This works fine, but I would like to add the option for all Instructors. Is it possible to have the first item say "All" and then the rest of the rows be the records in the Instructor Table? I guess I could create a temporary table and make the first record say "ALL" and then add all the records from the instructor table to the temporary table, but I am hoping there is a better way.

Has somebody found or know of a better solution for this?

Thanks,