Hi there,
I have a form which is also build up with a subform. The form has four fields student_ID, Surname, Forename, and Numhus. The subform is build up of module and mark fields.
The problem is when I update any field on the subform (i.e., module or mark) the information is updated perfectly to the respective table, however, the Student_ID is added to the form table with empty fields in Surname, Forename, and Numhus. This in return creates a new record with Student_ID field only.
What I really want it to do is when I update the fields in the subform, it doesn't affect any other field in the main form.
Thanking you in advance
Regards
I have a form which is also build up with a subform. The form has four fields student_ID, Surname, Forename, and Numhus. The subform is build up of module and mark fields.
The problem is when I update any field on the subform (i.e., module or mark) the information is updated perfectly to the respective table, however, the Student_ID is added to the form table with empty fields in Surname, Forename, and Numhus. This in return creates a new record with Student_ID field only.
What I really want it to do is when I update the fields in the subform, it doesn't affect any other field in the main form.
Thanking you in advance
Regards