using multiple click boxes to store entries

[steve]

Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga

[MacDermott]

I think your needs will be best served by a multi-select listbox.
This may not be exactly the layout that has been requested, but I think your
users will find it most convenient.
It won't be hard to select "all", either, depending on whether you set up a
simple or extended multi-select.

A multiselect listbox is by nature unbound, so you will have to write some
code to get the data from the listbox into the table - and vice versa when
you want to redisplay information which was entered previously.

Are you comfortable writing a few SQL statements?
- Turtle
"steve" <st*************@yahoo.com> wrote in message
news:49*************************@posting.google.co m...

Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga

[steve]

Hello, I solved this problem by using a subform with a combo box.
Isn't perfect but it will do what is needed.
Thanks for any replies. =)
steve

"MacDermott" <ma********@nospam.com> wrote in message news:<TB****************@newsread1.news.atl.earthl ink.net>...

I think your needs will be best served by a multi-select listbox.
This may not be exactly the layout that has been requested, but I think your
users will find it most convenient.
It won't be hard to select "all", either, depending on whether you set up a
simple or extended multi-select.

A multiselect listbox is by nature unbound, so you will have to write some
code to get the data from the listbox into the table - and vice versa when
you want to redisplay information which was entered previously.

Are you comfortable writing a few SQL statements?
- Turtle
"steve" <st*************@yahoo.com> wrote in message
news:49*************************@posting.google.co m...

Hello, I am using ACCESS 2000 and am currently trying to make a
database for a police department and they have several types of
license classes. i.e A,B,C,D,E etc.
What they have asked for is a drop down box with all the types listed
and simple the ability to click on multiple check boxes to show what
class(es) of license the person has. I have read through most of the
articles on multiple list boxes but this is not my need. I dont need
the values stored in a single field, another table is fine but I can't
seem to figure out how to do this neatly.
Also a box labeled All would be helpful as there are many license
classes.
Any help would be appreciated
Thank You
Steve Spencer
Peace Corps Tonga