MultiSelect List Box (pre Access 2007)

[ShelleyS]

I want to achieve (in Access 2003) what the built-in function in Access 2007
does by allowing users to select multiple items in a combo box or list box.
See http://office.microsoft.com/en-ca/access/HA100311171033.aspx.

An example
-client table (Client ID, Company Name)
-issues table (IssueID, ClientID, Issue Description, Staff Affected)

I want users to be able to select multiple 'Staff Affected' in the issues
table. I don't want to create a third table for staff affected because I want
to keep my data entry form fairly simple. The Access 2007 solution would be
perfect but the problem is... if I convert to Access 2007, I lose all my
user-level security :-(.

The final result is that I want to run a query to see how many issues affect
Mary, how many issues affect Joe, etc.

Any ideas?

 

[Roger Carlson]

Pn my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ListboxSubform.mdb" which illustrates how to do something
like (although not exactly like) this. You can download it for free here:
http://www.rogersaccesslibrary.com/forum/topic329.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[ShelleyS]

I see where you're going with that and it is a nice solution. Where it falls
down for me is that my records appear in a continuous form and when I tried
that with your sample the information doesn't appear correctly (only the
currently selected records choices show for all records).

 

[Roger Carlson]

Ah. You're right. This solution won't work in a continuous form.

Sorry.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L