Is the Form open?

Yes the QuestionF is open. Do I need to have any others opened? There is nothing mentioned in the video about that.

You are referencing TestTakerF. That Form should be open.

Kevin, I hate to ask this, but, once I had the TestTakerF open, nothing still happened until I populated the boxes with information and without hitting the begin button. Is that how it should work?

TestCbo will need to be populated. That if the field on the Form you are referencing otherwise it is Null (or possibly 0).

Thanks for letting me know that. I know that wasn't mentioned in the video, and it makes me feel stupid when I ask a question I should know the answer to. Again, thank you for taking the time to help me with that. Hopefully, one day I will be able to grasp most of this and not be a bother to you guys so much.

No worries Ken. That's what we're here for :)

Enter Parameter Value

Thanks Alex for the link. Just so you all know, every time you sed me something I do copy it all and save it for future reference. It is much appreciated.

Once again, another query issue, and I hate coming to you guys all the time. I have tried all day to resolve this, and I am getting nowhere. Once again, on the Video Richard runs the query and gets answers in it, and I do it, and nothing populates the query, but the TestResultT does get the answers there. I have opened the form it refers to and the 2 tables on the video to just don't understand this at all. If it wasn't that I need to learn this for the course, I'd skip right past it all and go back to my SQL seminar part 2, I started.  I've attached a screenshot of all 3 screens on one image, and maybe there is another I need to have open, just not sure,

Did you rerun the Query after submitting an answer?

yes and still was blank.

Can we see the Form showing the fields that aren't populating
Then the Properties Sheet for one of them.

Alex, I am hoping that what you asked for is in this batch of screenshots. As you can see, when you push the Begin Test button, it loads into the TestResultT but never into the TestAnswerT or AnswerCurrentTestQ. It also does nothing to fill the TestResultAnswerT. Also, the only property sheets that had anything you can see are the one for the form and the Begin Button. Do you need the coding so far for all this?

TestResultAnswerT will only have a record added to it when you select an answer to the question and click the Submit Answer Button.

Thanks, Kevin, and as far as the AnswerCurrentTestQ, if it does not show anything like it did on the video, that is not a problem either?

Have you gotten to the point where you display the Q on the Form?

Lesson 2?

I'm just about there now. But now another issue has come up. I placed the Default Values into the Tables as instructed and the order numbers are not working for the planet quiz. Instead of advancing they are staying as 0.