Populate to Multiple fields

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

I have created a combo box that allows multi-select values. The client would
check off the questions that pertain to them, and then I would like the
questions they checked off to populate into a subform into indivdual rows.
Could someone tell me if this possible?

So an example would be: The client checks off question 1, question 5,
question 6 etc., then the subform (datasheet view) should look like this:

Answer Comments Employee Responding
question 1
question 5
question 6
 
I have created a combo box that allows multi-select values. The client would
check off the questions that pertain to them, and then I would like the
questions they checked off to populate into a subform into indivdual rows.
Could someone tell me if this possible?

So an example would be: The client checks off question 1, question 5,
question 6 etc., then the subform (datasheet view) should look like this:

Answer Comments Employee Responding
question 1
question 5
question 6
Click to expand...

What's your table structure? Do you have a field for the QuestionID (you
should)?

You'll need to use some VBA code to loop through the multiselect combo's
ItemsSelected property to populate the questions. It might be just as easy to
have a continuous subform with a single select combo; you can select a
different question on each row. This would need no code at all.
 
I think you did not do this with a combo box, which doesn't support
mult-select. You can do this with a multi-select LIST box, though. Is that
what you meant?

Or perhaps this is an attachment field into which you've inserted files?

More information might help develop a good answer.

Thanks.
 
John,

Thank you - that is what I what I am trying to do. I will need to do the
"loop through code" as you suggested. I dont think I can do it the
continuous way since we are trying to save the client time when selecting the
questions. Do you know of any sites where I can find this type of code?
 
John,

I do have a field for the questions id. I should also note that it is a
mulitvalue combo box and NOT a list box. I cant find the ItemsSelected
property that you mentioned on the property sheet.
 
Back
Top