Hi I am new to access. I have a form with 8 combo boxes for 8 different tests e.g. Test1, test2, test3.... test8. I will then selects pass, fail, referred or absent for each tests. If a student passes all eight tests then i will select pass from each combo box for the respective tests. If...