Multiple Records with similar values

[alhk10]

Hi Everyone,



I'm trying to create a access form for attendance keeping purpose. Lets say it's 11 July 2018 4pm and the class name is "junior". How can I add multiple students to this class at a go instead of keying in one by one.

Thanks

[ranman256]

make a master form for the Class table:
[classID], [Meet], [ClassLevel]
123, 11 July 2018 4pm, Junior

and a subform (bound to a sub table) for the Roster table:
[classID],[StudentID]

a student table holds the IDs
[StudentID], [FirstN], [LastN], etc

If all the students are in the tStudent table, then you can use a listbox on the subform (mentioned above)
to just dbl-click a student from the list ,which runs an append query, which adds them to the tClassRoster table