Storing the data from a multi-select list box

  • Thread starter Thread starter Melissa Cowan
  • Start date Start date
M

Melissa Cowan

I have a question on what the best way to store the data from a
multi-select box is. Here's some info on what the database is like.

The first form a user would get is a form where they enter a problem
that need to be resolved. Each problem has it's own unique ID number.
From that form they then click a button which takes them to a form
where they enter actions to resove the problem. These actions can be
assigned to multiple people. I have the control set up where they can
select multiple people but I need to know how to store this info. The
other issue with this is that each problem can have more than one
action.

Should I assign the actions a number and then store the people's names
in a table with the problem id and the action number? If so, how do I
write the values that are selected to a table?

I'm using Access 2000 and any help or pointers would be appreciated. I
have had classes in VB programming and Access but nothing that
involved anything this complex

Thanks!
Melissa
 
Hi,

If you don't have a form with controls associated to fields of table,
you can append records to a table either by opening a recordset and
appending record to the recordset, but that is not the simpler way, since
you can also append the data directly:

CurrentDb.Execute "INSERT INTO tablename( ActionID, PeopleID) VALUES
( 10102, 1101) "


insert a new record in the mentioned table, with ActionID=10102 and
PeopleID=1101


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top