How can you have a multi selectable form?

[techtony]

Basically I want to list some records that are pulled from a query. On this list, I would like to have the user be able to select the records they want to act on by checking a checkbox - several of them most likely. When done selecting the records they want, I would like for them to select an action from a combobox at the bottom of the form or report.



This will be used to assign records to a person in the department if that helps to describe this better.


Any suggestions on how I can do this?

[pbaldy]

It would help to know the possible actions, but perhaps this gets you started.

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

[techtony]

That list would be a mile long

I was thinking of having a list with check boxes and the user check the box of the records they want to select and then a combobox at the end of the form that would allow them to assign the record to an employee (listed in the combobox). Then they hit save and the assignments are made. If this is not possible, Then I guess I can try something like your example. Thanks for the suggestion though

[pbaldy]

If you mean a form or subform, it's possible but there needs to be a field in the underlying table to hold the checkbox value, which would be problematic in a multiuser situation.

[amrut]

You can use a multi-select list box.