Evaluation Form

[scottmvinovrski]

Hi everyone,
I have a form that I am creating for the trainings at work for their training classes. Upon completion of the class, the trainess fill out an evaluation form based on how well the class was asking several questions rating each question 3 strongly agree, 2 Agree, and 1 Disagree. I am not having problems creating the form but is it possible to have somewhere at the bottom of the form were it will add the totals based on what they selected from the drop down menus?

 

[CraigDolphin]

You could use the After_Update event of each combo box to calculate the total and assign it to an unbound text box on your form.

For example, if you have three combo boxes (cmbo1, cmbo2, cmbo3) and a textbox (txtresult) it might look something like:

Private Sub After_Update cmbo1
Me.txtresult = Nz(Me.cmbo1,0) + Nz(Me.cmbo2,0) + Nz(Me.cmbo3)
End Sub