allow user to check boxes for records that need to be exporte dto word template

[Mwam]

Hi,

I have a database of different projects (that various employees have worked on) and then a query that selects the projects for each employee. I want the user to then select projects (relevant to that employee) that must be exported to a word template. How can I incorporate check boxes into the report that would let the user select only those projects that need to be exported?

Thanks!

 

[pbaldy]

In order to use a checkbox, there would have to be a field in the underlying data that it could be bound to. Would a multi-select listbox work for you?

 

[Mwam]

Thank you for the response pbaldy. could you please expand on what you mean by a "multi-select listbox"?

thanks

 

[pbaldy]

A listbox that allows the selection of more than one item.

 

[Mwam]

Yes, sounds like that could work since I want the user to be able to select multiple projects. How can I create such a list?

Thanks!

 

[pbaldy]

Put a listbox on your form, then in it's properties set the Multi Select property to Simple or Extended. You then need code to get the select values. Basically you need the loop and related code from here:

http://www.baldyweb.com/multiselect.htm

Inside the loop, do whatever you're doing with each item.