In a questionaire Database How do you get the responses to work?

Hello,
I am doing a database that is in a questionaire or survey format. This is my first time doing this.

I have a table for questions and a table for responses.
This is what I have Im trying to have a dropdown that is based on the questionID

tblquestions
QuestionID#

TblResponseList
QuestionID#
Responses


FormTest

This is giving me a error but is not explaining why.
=DLookUp("[QuestionID#]","[tblFS3ResponseList]","[Responses]= [Forms![frmTest]![QuestionID#]")

When you make the form how do you make the answer part show the drop down answers for the questions if the response answers are in another table?
Questions
When you have over 200 questions is it wise to put the questions in two colomun fields
AnswersAnswerResponse.JPG
gigifarrowAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gigifarrowAuthor Commented:
Does anybody know what Im doing wrong?
0
Jim P.Commented:
Two hundred questions? And they are all relevant to the topic?

From a quick glance at your question history you need to take a look at normalization.

There should be a table for the overall object (roughly guessing a tank or other mil vehicle).

Then have individual tables that has info on the turret, engines, operators, maintenance, etc.  and are linked to the overall object.

You'll probably want to have a history table because the maint guys will  take a useable part(s) from an overall dead object and move it to another that is still working but the individual part(s) are dead on the working object.
0
gigifarrowAuthor Commented:
Two hundred questions? And they are all relevant to the topic?

Yes they are. All this information is for one vehicle. It was written by the users.

From a quick glance at your question history you need to take a look at normalization.

Hello, I know what nomoralization is and if you want to get technical about my questions. I inherited two datbase that were not made correctly. So I was doing the best I could until I got permission to remake the database. Now Im am redoing both databases.
This  database is setup based on "At your Survey" .


All the question that I need information on are going to be dropdowns.

All  Im asking is what is wrong with the code. I am trying to make the answer part show the drop down answers for the questions. But since the response answers are in another table. I was trying to have the response column show the responses pertaining to that question.
0
Jim P.Commented:
Have you tried it this way:
=DLookUp("[QuestionID#]","[tblFS3ResponseList]","[Responses]=" &  [Forms![frmTest]![QuestionID#] ) 

Open in new window


Assuming that QuestionID#] is an integer.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gigifarrowAuthor Commented:
Thank you for your time and answer.

I have tried different ways to get a continuous form to lookup responses based on questions
in contol source

=DLookUp("[QuestionID#]","[tblFS3ResponseList]","[Responses] = [Forms]![frmTest]![QuestionID#]")
This takes the first Question and repeats it all the way down to the end of the form and doesnt show anything in the dropdownExample1
Then I tried this SELECT [qryResponses].[Responses] FROM qryResponses; in the row source in a unbound text

it shows all the data for the dropdown not the one that pertains to that question. And question one is duplicated all the way down the form.

Example2ContinuousLookup.accdb
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.