Hi,
On a form I have a subform 'frmStudentEntrySubform' in which 'CourseOrder' is a number field, and 'CourseName' which is a text field(I have added a combo box here). For each student I enter '1' in CourseOrder and select a course from the combo. Then '2' in CourseOrder, the next course, and so on. i wonder if there is a way to eliminate the need to enter the order numbers? My idea is, '1' should be there in the first row, and when we select the first course, '2' should come in the next row, and so on. A bit of code in the AfterUpdate event of the combobox, perhaps?
These numbers are actually stored in a table, as the order is necessary later.
I would greatly appreciate it if anyone can help. Thanks.