Drop down menu

[DenizBerkel]

Hi,
I have a table with questions and answers. I want the answers to be selected from a drop down menu. The problem is that for each question the answer options are different. That means I need to prepare different drop down menus for each question.
Can anybody give any idea how to do it?
I've attached the table as well.

Thank you very much...

 

[CJ_London]

Providing your answers are as per your table - i.e. text separated by commas - and your answer is going into rating then the following should work.

1. Create a continous form based on the table
2. Have two controls, Questions and Rating - Rating should be a combobox with bound column=1, columncount =1 and rowsourcetype=value list
3. in the Form Oncurrent event put the following

Rating.Rowsource=answers

You haven't explained how this is intended to work - but basically as designed at the moment, all you have is one question, one answer. If more than one person is going to answer the question then you need to repeat the question - and have another field to identify the user. Which is bad design

 

[Mihail]

This database is not (and can't be) exactly what yo are looking for.
But, I hope, you will find useful techniques to develop your own.
Good luck !