Using data from a table as questions for a form? Possible??

[odiem00n]

I am having trouble with my database and I have already tried searching through the forums for an answer.

Problem: I have a table (tblQuestions) with a list of questions that we ask questions - we may not ask all -, but pretty much a question bank. Another table (tblResponseAnswers) stores all the answers from each client.



The problem lies within trying to have a form (preferably in Data Sheet View) with a column that displays the questions inputted into the table from tblQuestions and the other column for response.

How do I recall data from a table to be the question in form?

If anyone can point me in the right direction, I would appreciate it!

[TheShabz]

To answer the question as you have it, you would create a query:
SELECT * FROM tblQuestions
and use that to create the subform in datasheet view using the form wizard.

Now. I am perplexed as to why you want to do it that way. Will the questions be answered in that same form? The way I would go about creating an interface for answering questions is as follows (assuming all questions have the same possible answers):

I would have the same tables you have. Each question would have a questionID and each answer would have an answerID. I would create a textbox that would pull the first question (VBA used) and have my possible choices as an option group below it. I would let the user pick from the option group, and have a button that would store the answer, clear the option group, and display the next question from tblQuestions.

I know for a fact that links to pre-built questionnaire dbs have been provided in these forums. Try looking for them here or on a google search if you dont want to build from scratch. Personally, I enjoy building from scratch because it forces me to practice VBA, which I am not too proficient at.

Hope this helped.