Basic Form Design Assistance with 1 to many; Form to Subform technique

[WallyZ]

Given the following schema

tblStudent
Student_ID, Surname, Name

tblSubjects


Subject_ID, SubjectName

tblGrades
Student_ID, Subject_ID, Grade

qryStudentGrades
Student_ID, Subject_ID, SubjectName, Grade

And given the obvious relationships (I hope it's obvious)

I have used the form wizard to design a simple form (student) & subform (grades) .

I changed the subform view from a data sheet to a form but then lost the mechanism to navigate between the various grades.

So I added a combo box to the subform to select the required grade.

This worked and all the other fields on the subform update on any selection form the combo box and any changes made in the fields are reflected back into the database.

So far so good.

However where there is no record of a grade for a particular subject against a student then there is no entry in the combo box list and so it cannot be selected, which prevents a new record from being created.

I'm new to Access and thought this must be a familiar issue.

So I don't have to re-invent the wheel what method should I use to create a new grade record in the grade subform where a previous record did not exist?

If a new grade record is created it must be against a valid subject.

Any sample code with something similar would be helpful!

[orange]

Look at the combobox properties, it probably has LimitToList = Yes.
If you switch it to NO, I think you can add a new entry.

There are samples of various combo things here.
and here