Filter Access Report based on Checkbox selection

[KrisDdb]

I have a query that gives field values like name, age, department, etc for all the staff members in our company. These fields are obtained from many other tables and queries. Now I am planning to generate a report, which would display the results of this query. The catch is I am trying to do it in such a way that I want the user to have the option to select for which staff members he wants to run the report.
Example: if I have 10 staff members, the user should be able to select staff3, staff6, staff7 and run the report such that it displays all the field values from the query related ONLY to these 3 staff members.
I have this design in mind. I was thinking of using a form for this. I could put up some labels and checkboxes for each staff on the form, and then select some checkboxes and get the report to read which checkbox is selected, and then display the concerned results through the report. But I am not sure of how to go ahead with it. Also, I am not sure if this is the best method to do it. If anyone knows how to implement this, or if you know of a better/easier method, please let me know.
Appreciate you time and thoughts.

[pbaldy]

I'd probably use a multi-select listbox:

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

It would be more dynamic than check boxes, which would require you to modify the form every time you got a new employee.

[KrisDdb]

Hi Paul

Thanks for the quick reply.

This method seems to be perfect for my situation. But I dont know where the trouble is, but my DB is crashing when ever I try to open it after I put the code for the form. When I open a backup without the form code, it opens properly! (So I believe theres no trouble with Access at least) Its kinda weird but thats what is happening
I tried repair and compact.. It didnt help either. Any thoughts as to whats causing the trouble? And suggestions as to what I can do?

[pbaldy]

Did you just copy/paste the code, or did you try to copy the actual objects from one db to the other? I've heard of corruption issues when trying to copy actual objects. I would just create your own objects and then copy the code over and adjust it for your names. Certainly at this point I'd start from another copy of your backup (which was smart of you to make).