Choosing more than one item in a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't figure out for the life of me how to choose more than one option in
either a Look-up list when viewing it in a form - or when you create an
option box in a form. How can you choose more than one item? I don't know
the best way to go about doing that. If you just create check boxes one by
one, how will that information link to your table . . .it won't. Any advice
of what I need to do???
 
rlmanderson said:
I can't figure out for the life of me how to choose more than one
option in either a Look-up list when viewing it in a form - or when
you create an option box in a form. How can you choose more than one
item? I don't know the best way to go about doing that. If you just
create check boxes one by one, how will that information link to your
table . . .it won't. Any advice of what I need to do???
Click to expand...

Since it violates proper database design to store more than one value in a
single field Access doesn't provide an easy way to do so. You should have two
tables with a one-to-many relationship. Same idea as one sales order with many
line-items on the order.
 
I keep seeing this post in different newsgroups. If you must post into more
than one newsgroup then crosspost by putting the newsgroup names in the
Newsgroups window. That way, an answer in one newsgroup will percolate to
the rest of them thus saving people answering a post that will never be read
because you were answered elsewhere.

HTH
 
I thought of that, but don't know how to get it to look the way I want. I
thought in one table I'd need an ID column in autonumber and then the next
column or field name to be "complaints" with each complaint listed. Do you
then set the relationship to your original table and have that field name
formatting be Yes/No? I want them to appear in a check box format on my
form. Does that make sense? Please help!!
 
I only posted it in this newsgroup so if there is more questions out there
about choosing more than one item in a list I'm unaware of them and they're
not from me. This is my first time asking a question on this discussion
group so I don't know all the ins and outs of crossposting etc. Sorry for
the annoyance.
 
rlmanderson said:
I thought of that, but don't know how to get it to look the way I
want. I thought in one table I'd need an ID column in autonumber and
then the next column or field name to be "complaints" with each
complaint listed. Do you then set the relationship to your original
table and have that field name formatting be Yes/No? I want them to
appear in a check box format on my form. Does that make sense?
Please help!!
Click to expand...

Sometimes designing the database properly and having the user-interface you
desire are not compatible. I know of no easy way to do this with CheckBoxes.
 
If You have a "ListBox" with items in it or names, in case
to select more than one item, you need to change
the "Multiselect" property of this list box from "None",
to "Simple" or "extended"

Hope this help.

Thanks,
Marsela
 
Don't tell me it's that easy! Where do you do that? I looked in properties
and didn't see where to do that. I have gone through soooo much crap trying
to figure out how to do it. I would really appreciate more help!

Thanks,
Becky
 
It isn't that easy. You can't (without some code) and shouldn't store
multiple values in a single field. The values should be stored in a related
table where each "selection" would create its own record.
 
Back
Top