Developer 10 TestTaker 7 - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Developer 10 TestTaker 7

Thomas Gardega

3 years ago

I have been working on access Developer 10 test taker. I am up to test taker 7. everything works fine up to the point where I have the following code:
AnswerGivenList.RowSource = "Select AnswerID, AnswerText From AnswerT" & "Where QuestionID=" & QuestionID It is not displaying the list of answers for the test question. The AnswerGivenTextBox and the AnswerGivenList Box are visible as desired by the type of question. I have checked the answer table and everything is spelled correctly. I do have the QuestionId box on the TestTakerF I have put in 2 days trying to figure out what is wrong. any tip s on what to look for from others who had a similar problem. Thank you
Tom Gardega

	Kevin Robertson @Reply 3 years ago
There is no space between AnswerT and WHERE. You don't need to concatenate two strings together at that point. `AnswerGivenList.RowSource = "Select AnswerID, AnswerText From AnswerT Where QuestionID=" & QuestionID`

	Thomas Gardega OP @Reply 3 years ago
I figured it out. There was no space. & "where QuestionID=" & Question ID should have been & " where QuestionID=" & Question ID

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View