option group value is value from field

[Guest]

hi!

I want to create an Option group, with the labels 'Foundation' and 'Higher'.
When 'Foundation' is selected, i want this to place the values from the
'GermanExaminationMarkF' field PLUS the value from the 'GermanCourseworkMark'
field into the 'OverallGrade' field.

However, when the option next to the label 'Higher is selected, i want this
to place the values from the 'GermanExaminationMarkH' field PLUS the value
from the 'GermanCourseworkMark' field into the 'OverallGrade' field.

Any ideas of how to solve this would be much appreciated!

Thank you in advance!

 

[Graham R Seach]

Emma,

Private Sub myOptionGroup_Click()
If myOptionGroup = 1 Then 'Foundation and Higher
Me!OverallGrade = Nz(Me!GermanExaminationMarkF, 0) + _
Nz(Me!GermanCourseworkMark, 0)
Else 'Higher
Me!OverallGrade = Nz(Me!GermanExaminationMarkH, 0) + _
Nz(Me!GermanCourseworkMark, 0)
End If
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia