I've setup a survey database with about 50 questions. I'm curious as to how I can create a form that will work with my database. I have 3 tables, 1 employee table with a primary key as an employee id. 2nd table is just a lookup table with all the questions in it (so just 2 columns), then a 3rd table which link the first two tables together which employees will go in put in their employee_id and for each record it will have a/an employee_id, and a question, (and of course an answer). So the question field is a combo box off of the 2nd lookup table. Any ideas??? Thanks so much.

Hi there, I'm not really sure exactly what you want to do here but I've just finished creating a questionaire using Access, I think your trying to do a similar thing???

yes, that's exactly what I want to do, I would like to see how you setup the form, so that your can see multiple questions at once. -db

It hometime in the UK now, but I'll post back tomorrow http://www.access-programmers.co.uk/ubb/smile.gif

Excellent, Thanks very much!

hi there, OK firstly I think you have your tables set up incorrectly. you need your employees in one tables, with the primary key, and you need another table with a field for each answer and a field for the key to link on, set up as one to many, employees to answers.

The way I collect data is to have a form and subform, the form would have the employees and the subform the answers. I have the subform set up as tab pages so your not opening new forms all the time.

I hope this is enough information to get you started, I can email you screen shots if it'll help, just send me an email.

HTH