My user would like to select different companies from a Datasheet form that I have created. He would like to select multiple companies so that they can be moved into another table for export.

The form that he will use does not have to be a datasheet form, but he would prefer it to look like this. Can anyone tell me how I can go about doing this?

Thanks!

Why don't you use a multi-select listbox? That way you can select multiple items and you can have multiple columns... Hope that helps.

Doug

Thanks. I'll have to look into this.

Currently I have created an extra field in my table. I'm trying to make it so that if the user checks this box on the form for which ever companies they want. They can then run a query that will then export records for companies that have this check box set to true. After this happens I'm going to try and set the check box back to false.