I have created a form using VB in which a student enters his details and the marks he got on the 8 different exams he worte. I want a code in which the marks the students enters are calculated and the average is displayed on the form on a text box and when the student presses the submit button, that average should be stored in the table also together with the average.
Below are the fields in the form;
-Exams 1 to 8 Fields(The student wrote exams)
-Average (this is the field that should display the average automatically)
Then there is the cancel and the submit button
I have linked this form to the table already.