Drop down boxes

[mich]

Hi,

I am trying to create a database to analyse approx. 2000 customer surveys. There are 21 questions, each with a totally different set of answers. How can I create a drop down box in each field with the relevant set of answers to choose from?

Mich

 

[EmmaJane]

Hi,

I am trying to create a database to analyse approx. 2000 customer surveys. There are 21 questions, each with a totally different set of answers. How can I create a drop down box in each field with the relevant set of answers to choose from?

Mich

Try doing a search on combo boxes or list boxes, or depending what you are trying to do at the table level you can use the lookup wizard.....

 

[Mile-O]

Actually, a better search would be on surveys or questionaires as the questions comes up every now and again.

You might find that a form is a better way to go than directly putting info into a table, and that it would be best to get the table structure sorted.