Looking to have more then one selection from the combo box be inp.

D

d_klepk

Hello i am setting up a form for an inspection process i have about 10 or so
questions i am looking to have on this form. I have answers written out to
each question in another table that is linked to my drop down boxes for the
questions, and from there the selection goes to another table for record
keeping. I am looking to have this ability to select more then one of those
answers and have access put 2 or even more of these answers in the same feild
for the record is there anyway at all that this can be done.
 
R

Robert Zeurunkl

d_klepk said:
Hello i am setting up a form for an inspection process i have about 1
or so
questions i am looking to have on this form. I have answers written ou
to
each question in another table that is linked to my drop down boxes fo
the
questions, and from there the selection goes to another table fo
record
keeping. I am looking to have this ability to select more then one o
those
answers and have access put 2 or even more of these answers in the sam
feild
for the record is there anyway at all that this can be done.
Click to expand...




Storing more than one data element in a field is not usually a good wa
to do things. Field length limitations often will come into play whe
you allow "any number of responses" to be stored in a single field.
can see it now, "yeah, but I never thought they'd try to stuff all 1
responses into my little 255 character field." ;-)


But I can see where it would be useful in your case. And in fact, I'v
done similar things myself. Here's what I'd recommend. Hopefully yo
can do this without a major rewrite.

A combo box will not do what you are wanting, but a list box will.

Populate if from a table that has rows that have an ID field.

ID RESPONSE
--- -------------------------
A1 I know this already
A2 I might know this
A3 I kinda sort know this
A4 I definately do not know this

I don't use listboxes very often, but I think you can make the
multi-column and hide the ID part by making it's column width ZERO

Show the RESPONSE part, but hide the ID part.

Afterwards, when you are processing the selections from the listbox
you can store the selected ID's in your database field separated b
commas.

tbl_Form_Responses!Responses = "A2, A3"

You can then always parse this field, extract the ids and go back t
your responses table to get the text of their responses, and at th
same time store only a minimum of data
 
Top