Selection Help!

[DarkOne72]

Hi All,

I am not sure how to tackle this porblem I am having.
What I want to do is make it where I have a form with a list of certain records with Name, Phone Number and employee number that is pulled from a query. The query part is working properly but what I want do on the form is show the above infomration (name, phone etc..) and have acheck box next to it and if it is checked when I hit a button it will open a report with only the checked boxes. can someone assist please?

Thank you...

 

[MajP]

There is no real easy way to do this. You can not use an unbound control, so you would have to have a field in a table for "selected". This would probably require as the form opens to run an update query to clear out that field, or you will have to do it manually. Then the report can be based on a query where "selected" is true.

A common way is to use a multiselect listox. Then pick your multiple names, and you can build a query off that control. Look in the query FAQs for using listboxes. There is an example that is flexible.

I personally use a listview control to do this because it has a listbox with checks. But it requires a lot of code to manipulate.

 

[DarkOne72]

hmmm...I will haev to look that up as I have not done that before, thank youfor the information. If you have any examples that would be awesome!

Thank you again.