• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1817
  • Last Modified:

Access Form List box using Multi Select = Simple

I'm using a list box (List0) Multi = Simple. How is the selected data stored and how can I access it.

 
0
arnier13
Asked:
arnier13
  • 2
1 Solution
 
peter57rCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now