I am a bit stumped. I got the coding correct, I believe, per the video; however, when I run it to get the question and answers correct or wrong, it all comes up correct. I must be missing something, but I even checked the handbook, and it looks the same as on the video. Any ideas?
Ken WykoffOP
@Reply 9 months ago
Kevin Robertson
@Reply 9 months ago
The first line of your if statement is wrong. Change to the following:
If Answer = Q1 + Q2 Then
Paul Kiener
@Reply 9 months ago
Also the line beginning with "Answer", you have "Q!" instead of "Q1"
Ken WykoffOP
@Reply 9 months ago
Paul Thanks, Paul, I just found that finally, before logging back on here. After changing it, it still didn't work.
Ken WykoffOP
@Reply 9 months ago
Kevin Thanks Kevin, I will try that but look at this screenshot from the video lesson too please. It worked fine for Richard, just not me. Let me try your way too.
Ken WykoffOP
@Reply 9 months ago
Ken WykoffOP
@Reply 9 months ago
Guys, I also forgot to mention the debug yellow line goes through the line: Answer = InputBox....
Ken WykoffOP
@Reply 9 months ago
Kevin, your way worked for me and thank you.
Donald Lader
@Reply 9 months ago
Ken,
Richard has If Q1 + Q2 = Answer and you have If Q1 + Q2 + Answer. Kevin addressed this and this is why it works. The original code is fine.
Ken WykoffOP
@Reply 9 months ago
Donald Donald, great eyes and thanks. I looked it over several times and never saw that till you mentioned it. Thanks.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 3.