Hi there,

I am fairly new to Access so please forgive me for my ignorance. I am using a SQL Server 2005 back-end and an Access 2007 front-end for an application I'm developing. I am trying to create a form where the user can select multiple Auditors and multiple Auditees. The Auditors are generated from an Auditors table and the Auditees are generated from an employee table. I understand that I can use a listbox, but there are hundreds of records in the Employee table and that will not make it user-friendly. Is there an alternative besides using a listbox to allow multiple selection? I know multi-value is not supported in SQL Server so a solution that will make it easy to integrate with SQL Server would be great. Thank you!!