How can I use a multiple selection list box to store multiple ans.

I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!

This is not the normal method of storing multiple values. The accepted
method is to use a subform that is bound to a related table like the Orders
and OrderDetails in the Northwind database.

Can you get around not using a list box?

--
Duane Hookom
MS Access MVP


"Maree_in_Australia" wrote in
message ...
I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!

On Sat, 22 Jan 2005 15:49:03 -0800, Maree_in_Australia
wrote:

I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!

In a relational database, one does NOT store multiple values in a
field. Instead, you should use two tables in a one-to-many
relationship; and store the multiple values in the "many" side table.
A Subform is the simplest way to do this. If you really need to do it
using a listbox, I've got some sample code which will move selections
from a Listbox into a many-side related table.

John W. Vinson[MVP]

Hi Marie.

As Duane and John have explained, using a list box to stuff lots of
different items into one field is a really bad design - even in Australia.
:-)

One of the most basic rules of relational data is that each field must be
atomic, i.e. it must contain only one thing. To read further about this,
search for "normalization".

Micorosoft's basic introduction is he
http://support.microsoft.com/default...b;en-us;209534

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Maree_in_Australia" wrote in
message
...
I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!

HI I found this post in my search and I am interested in the sample code
which will move selections from a Listbox into a many-side related table. I
DO have two tables in a one-to-many relationship; and store the multiple
values in the "many" side table.

I realize asking for this is bad form but I want to compare my options.

Thanks bunches!!
Shel

"John Vinson" wrote:

On Sat, 22 Jan 2005 15:49:03 -0800, Maree_in_Australia
wrote:

I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!

In a relational database, one does NOT store multiple values in a
field. Instead, you should use two tables in a one-to-many
relationship; and store the multiple values in the "many" side table.
A Subform is the simplest way to do this. If you really need to do it
using a listbox, I've got some sample code which will move selections
from a Listbox into a many-side related table.

John W. Vinson[MVP]

You might want to search Roger Carlson's small sample databases at
http://www.rogersaccesslibrary.com/TableOfContents3.asp. Search for this
file or possibly others ListboxSubform.mdb ( intermediate )

--
Duane Hookom
MS Access MVP


"Shel" wrote in message
...
HI I found this post in my search and I am interested in the sample code
which will move selections from a Listbox into a many-side related table.
I
DO have two tables in a one-to-many relationship; and store the multiple
values in the "many" side table.

I realize asking for this is bad form but I want to compare my options.

Thanks bunches!!
Shel

"John Vinson" wrote:

On Sat, 22 Jan 2005 15:49:03 -0800, Maree_in_Australia
wrote:

I am trying to set a field that will accept multiple selections from a
list
box. Please Help!!!!

Urgent!!!!

In a relational database, one does NOT store multiple values in a
field. Instead, you should use two tables in a one-to-many
relationship; and store the multiple values in the "many" side table.
A Subform is the simplest way to do this. If you really need to do it
using a listbox, I've got some sample code which will move selections
from a Listbox into a many-side related table.

John W. Vinson[MVP]