Search results

Dear Uncle Gizmo, you are quite correct. The main form contains the individual student details including the student ID number (Access generated). Embedded in this form is a subform which contains the student ID, the term number and the report number. The forms are linked by Student ID. The...

Thanks for the reply UG. I have looked again at the description and the list and I can't see how they don't match. What am I missing? Apologies if it is not clear. Anyway, in short: Student x will have 3 terms (Term 1, 2, 3). In each term he will have 3 reports, so 'Term 1' will...

Hello folks I have a form with an embedded subform which is based on a query. What I'd like to do is the following: For each new record I'd like the field [Term] to increment by 1 so that with the default value starting at 1, the next record will show 2 and the next will show 3. After 3 has...