Solved

Access Form List box using Multi Select = Simple

Posted on 2008-10-17
3
1,805 Views
Last Modified: 2013-11-28
I'm using a list box (List0) Multi = Simple. How is the selected data stored and how can I access it.

 
0
Comment
Question by:arnier13
  • 2
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22740348
Access 2003 does not store the selections of a multi-select list box.
To store mult-selections you would have to write code to store multiple values and write further code to decode the stored values.

0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 22746849
arnier13,

1. You might want to switch to "Extended" multiselect mode, becuase it works in the way most people expect from a Windows program.

2. When you select multiple values you can use a loop to "Accumulate" the values.
You can then use the values as multiple criterion in a query. (ex: WHERE Country='USA' OR Country='Spain')

See this link:
http://support.microsoft.com/kb/135546

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22758873
OK,

But Peter57r also answered you question as well, but from a different perspective.

You original request was how to "Access" these values.
Therefore Pete's suggestion of writing code is a actually the more accurate answer to your original question as posed.

You should have really split the points.

Please click the "Request Attention" button in your original post, to have this changed.

Thanks!
;-)

JeffCoachman
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now