>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,
Surely, you can collect records to a cursor add one more record with "All" and use it as Rowsource. Another good solution is just add check box "All Instructors" to the form, and add code to Check.InteractiveChange to make Combo.Enabled=.f. and Combo.Value="", when checkbox selected.
Edward Pikman
Independent Consultant