By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,122 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Multi select list boxes in Access

P: n/a
Hi5
Hi,
Is there any chance of getting to know how to make a drop down as a
Multi select list boxes in Access?
Many Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 27 Jun 2005 01:30:17 -0700, "Hi5" <fk***************@yahoo.com>
wrote:
Hi,
Is there any chance of getting to know how to make a drop down as a
Multi select list boxes in Access?
Many Thanks


Yes. All you need to do is change the properties for the ListBox so
that it is a "multi-select" ListBox. Populate it "normally" (either
through a list or a reference to a query or table). When your user
selects one or more items in the ListBox, you can use VBA to work with
the selections made. This is typically done in the AfterUpdate event.

Google should have many examples of how to structure your code to
iterate through the ListBox choices, see whether each one is
"selected" and then do something with the results.

Good luck.

mike
Nov 13 '05 #2

P: n/a
comboboxes and listboxes are different in that regard. You can use a
listbox and set the MultiSelect property to something other than None.
then you can iterate through the selected items. Dev has code on his
website for it.
The hassle with using a mutli-select listbox as a pseudo-subform
(allowing a 1-M relationship) is that updating and changing the
selected values is going to be a pain. It would be much easier and
more flexible to use a combobox in the subform. (Well, in my opinion,
anyway).

http://www.mvps.org/access/reports/rpt0005.htm

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.