Questionnaires Database

[kahr3n]

Hi,



Newbie here, I am creating a database by which I have a table with Questionnaires which are 35 items and another table that contains the choices. I have no problem on interconnecting the values of each table like one question will correspond to one set of multiple choices such as A, B, C, and D. Now, what I want to do is to check if the correspondent got the right answer or not. Or in other words, in one question the answer is either of the four choices so at the end there will be total correct answers from the validation of the user answers and the right answers.

Attached herewith is the screen capture of the form of Questionnaires.

[TheShabz]

I assume you have a field with the correct answer in it.

If Me.cmbAnswer = dlookup("correctAnswer","tblName", "questionID = " & Me.txtQuestionID) Then
'Whatever you want to do

End If

the Dlookup essentially runs a quick query and pulls the resulting value. also not the concatenation because in a DLookup the criteria must all be strings. The basic format is DLookup(Field Name as String, Source Name as String, Criteria as String)

[kahr3n]

thanks for the reply, its awesome. actually, i have sorted out my own issue. i inserted a calculated field by which it compares the two values (1.Correct answer, 2. User Answer) then gives -1 (negative one) so at the end i just use sum function to calculate total numbers of right answers. gotta apply your suggestion on the other one.