MS Access 2007 Multi selection check boxes in a form

[patio]

MS Access 2007 Form. I need to create either check boxes or a mutivalued list in a form where the user can select more than one item. For example, I am creating a call list that tracks various information including the type of call or 'Topic Code'. The user wants to be able to track what the topic is for each call - but there may be several topics in one call, therefore the need to pick one or several options from the topic code lookup table for each phone call record. When attempting to do this using check boxes (with the control source pointing to the topic code lookup table) if one check box is selected in the form - all check boxes are selected. I don't know a way around this and was hoping for some suggestions. Thank you.

[bartonc]

Here on TheScripts, there is a truly great Access Forum where you will find help for you query.

[r035198x]

Here on TheScripts, there is a truly great Access Forum where you will find help for you query.

And this is now moved to the

[size=very, very, very small] great [/size]

Acess forum.