Entering Data into a Form

[Scott Reed]

I have 2 tables 1 is the correct results the other is peoples answers! Is
there any way I can enter 1 for Yes, and 0 for No and the computer will
compare the two the correct answers with the given answers and give a
result?


Thanks in Advance
Scott Reed

 

[Guest]

I would do something like this:

Create a form which contains a column textboxes called [Correct Answer 1],
[Correct Answer 2] etc bound to your correct answers table. Make them all
invisible. Add a column of text boxes for the user input called [User Answer
1], [User Answer 2] etc. Create another column of text boxes which each have
a control source like: =Iif([Correct Answer 1] = [User Answer 1], "Correct!",
"Incorrect!").

If this form is to save the user's answers, you will (I think) need to put 2
subforms on it, one to contain the correct answers and one to create the
user's answers, because the two tables are not related. There might be a
better way of doing it though so ask around.

Cheers

David