hi there i have a problem i can't figure out im doing a project in access that is a math quiz and im trying to figure out how i can put two textboxes for "correct" and "incorrect". in my form i have three txtboxes:

1 - number1
2 - number2

i have made these two txtboxes be random numbers from a button i press named "next"

below the two txtboxes is the third txtbox for the answer i named "useranswer" this txtbox the user enters what he thinks is the correct answer and if it is the correct answer a msgbox pops up and tells the user 'correct' or incorrect, but i want to add two more txtboxes to keep track of how many the user gets right and how many they get wrong with a percentage of there answers does that make any sense the purpose of the whole thing is when the user presses the button named "next" a new set of random numbers appear and the user enters the answer in the useranswer box. anyway thats the problem i can't figure out. i've tried using the "iif" in the control source of the two txtboxes "correct' and "incorrect" but i do'nt get how that is done any suggestions.

diaz123

Wow, can you post that in English?

What you want to do is create a non-editable text box with the status of the repsonse that the user can't see (set to Visible = No). When your message box pops up, add either correct or incorrect, or some value, to the hidden text box. Use ONE text box for both a correct and incorrect response, bound to a single field in your exam table (junction table).

Then create a query to do the calculations for you. For example, if you use Correct and Incorrect, create a query that counts the instances of correct and incorrect for the user and the test. You can use this to display a running total score on the exam form using the query and a subform.

Did that help? Did you learn to write on a cell phone? =)



mmcdonal

well no! i didn't learn to write on a phone thats the only way i could explain it i guess i wasn't thinking how others would read it sorry, but any way i figured it out but thanks for the response anyway (mmcdonal)

diaz123