How do I store multiple list box values in a table?

  • Thread starter Thread starter Zack
  • Start date Start date
Z

Zack

I am trying to store multiple values (selections) from a
listbox, in a table. For example: I have a member, I want
this member to belong to 3 groups, group 1, group 2, group
3. I have set up a list box and enabled Multi-Select so
that I can choose what groups this member will belong to
in one step. The list box reads from a table with values
consisting of the group names. I want to store the
selections that I make in the list box in a colum on the
form with the persons contact information. So basicaly, it
would look like this; Name: Joe Stevens Address: 123
anywhere st. USA GROUP: Group 1, Group 2, Group 3. Is
there any way that I can do this, I do know some visual
basic coding, but I just can't seem to get anything to
work for me. thanks
 
Zack,

Look at the ItemData, Selected and ItemsSelected properties for a listbox in the
Help file.
 
PC said:
Zack,
Look at the ItemData, Selected and ItemsSelected properties for a
Click to expand...
listbox in the Help file.


I must have the wrong Help File. In Access 2002, entering the search
string "It*" stops at "Italics". There is no Help in my file at all
for any string starting with "Item*". Entering "Selected" truncates
at "Select".

In previous versions of Access, pressing F1 in the middle of a task
brought up Help on the operation in progress or a keyword in which
the cursor appeared. Newer versions seem to have eliminated this
feature.

Any other references?

Thanks!
Click to expand...
 
Back
Top