Access. MultiSelect for dummies

[cristina m]

Hi,

I have been searching for info about Access 2003 MultiSelect option. I have found a lot of info, however, I do not know how to use it.

I want in my forms a field where I can select more than 1 value. It seems like you can do this with a list box. It is fine for me till here.

I have created the list box and I have introduced the values that I want to be shown (I have introduced them manually; they are not read from a table or query). The list box in called “applications” and the possible values are: Broadband and Broadcast (they could be more). I have selected MultiSelect=simple or extended in the properties. Doing that, it is possible to select 2 values.

My problem: I do knot know how to read that selection!! How to store it??!!

If the selection of that field is for a form which introduces data in a table, then I need those selected values to be stored in the field “applications’ in the table. So, there will be an entrance in the table whose field application is = Broadband Broadcast, if both are selected.

If the selection of the field is for a QBF, then I need the selected values to be used in the criteria in the query. For example, I can make a query to search those who have in applications de values Broadband Broadcast. Or search for those who only have Broadband…

All the info I found about this involves macros, and I found some code examples. My problem is that I have no idea about macros. I do not know where I need to save the macro code, or what to do to execute it… When I try to copy the code examples, I do not know where to copy them… Could someone explain me step by step, for dummies, what I need to do?

Thank you!

[NeoPa]

It sounds like you need to go and learn the basics of the subject first. We can make the answers simple, but we answer questions rather than tutor people in learning the subject from scratch. That is not what we've signed up for. The following links are some that may help you get to a state where you can interface meaningfully with questions asked and answered on here :

1. Microsoft Access Tutorial.
2. Microsoft Access Tutorials (Strive4Peace).
3. Microsoft Office Tutorials.
4. VBA Tutorial (Excel).

I don't know which will suit you best, but I'm sure you can find something in there to help you get started. You should appreciate what it is your responsibility to manage for yourself, and what others are prepared to offer of themselves to assist. It's an important line, and well worth avoiding crossing.

As for your question, the MultiSelect ListBox control has a property called .ItemsSelected which is an array of the items that the operator has selected. It's hard to provide anything more helpful at this stage with no context within which to place it (as you provide none). I'm sure you appreciate that such an answer, without context, is of limited use.