I am working on a questionnaire and I have an option group with 2 option buttons, it is displayed on a continuous form. I have 65 questions broken out on tab controls in groups of 13. I am trying to get a box to sum the score as they are answered. I added a text box with the following on each page:
For page 1 - questions 1 through 13
TotalScore=DSum("Score","Questions","Question between 1 and 13 AND CandidateID= " & [CandidateID] & "")
For page 2 - questions 1 through 26
TotalScore=DSum("Score","Questions","Question between 1 and 26 AND CandidateID= " & [CandidateID] & "")
Score being the field I am summing (0 or 1)
Questions as the table
Question as the unique identifier for each question
I have tried to put a refresh on the TotalScore - after update and on exit on the option group. But I am always one count off (or behind).
Any help would be greatly appreciated.