Limiting size of a field

[Manass]

Im doing a coursework on ms access on School Management System. I have a table 'tblSubject' containing fields: 'Subject ID' and 'Subject Name' . A student has the right only to choose a maximum of 8 subjects, that is , the field 'Subject ID' must have only 8 records/entries.



Could anyone help me how to do this ???????

[June7]

This is not limiting size of field but limiting number of records, unless you are using a multi-value field.

Possibly VBA code in form BeforeUpdate event to check if table already has 8 records for the student. Something like:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If DCount("CourseID", "StudentCourses", "StudentID=" & Me.StudentID) = 8 Then
Cancel = True
MsgBox "Eight courses already selected."
End If
End Sub