>Hello everyone
>
>I have a form with 6 combo boxes. They are all populated by 6 different tables (operator,shift,customer,type,decription,colour). The form is used to collect all the criteria needed for a report.
>
>The problem is they now want an option to select "ALL", this is not stored in the table. Could you please give me any idea's how to do this. Also "ALL" needs to be at the top of the combo's.
>
>Thanks
>
>Nicky
Use a list or array for your recordsource.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer