Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1745
  • Last Modified:

Access 2010 - How would I select multiple selections from a combo box to a text field?

Afternoon,

I am working in Access 2010 and would like to add a combo box to my form, which has the capabiltiy of allowing the user to select multiple items from it.

Screenshot below is what I am trying to achieve in access. This was obtained from Google Images.

multicombobox
I want this combo box to pull values from a column I have in one of my tables.

As the user selects the values of this combo box, I want the information to then be stored in one of the forms fields (seperated by a comma) which is a text field from a column in a "different" table.

Example below once user has selected all the items necessary from the combo box,

selecteditems
Can someone please let me know how I can achieve this?

Do let me know if additional information is needed.

Kind Regards,
N
0
nobushi
Asked:
nobushi
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
This is called a "Multivalued field"
*However* this feature is not so straightforward to implement and it is commonly mistaken for a simple One-to-may configuration.
It is also difficult to troubleshoot if problems arises.
See here for more info:
http://allenbrowne.com/Access2007.html#Mixed
(It was only ever created to interface with Sharepoint)

Then other side of the story is that the alternative interface may be just as confusing to design if you are new to database design.
Then basic concept of a Multivalues field is to create an interface for a Many-To-many relationship.
So before going any further, you must be absolutely sure this is what you need.
You also must have the tables set up in this configuration, else it will never work correctly.
Here is a basic tutorial:
http://office.blogs.webucator.com/2010/06/29/creating-a-multi-value-field-in-access-2010/
...but you can do a web search of:  Access Multivalued fields
for more info and probably a few youtube videos...
;-)

JeffCoachman
0
 
nobushiAuthor Commented:
Thank you Jeff.

Now that I know what I am looking for (since you have provided a definition), I will research this a little more to see if this is really the way I want to go.
0
 
Jeffrey CoachmanCommented:
Yes, I have seen member here actually modifying the basic table design to do this, ...only to discover that a simple one to many was all that was needed.

But a simple example is like Students and Classes
Since one student can be in many classes AND one class can have many students.
this is a classic example of a Many-to-Many relationship.
What the Multivalued field does is make it easy for you to select the "many" classes for a student.
OR to have a class and select the "many" students.
*remember this must be the case for both tables*

To wrap up.,.
...On the other hand, the "interface" is great, however the things you need to now about to get it working smoothly is the tricky bit...

;-)

JeffCoachman
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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