Your second post gets an A+. The previous merited an F. :-)
I would do batch assignments using an unbound form with two (2)
listboxes, one for the students, the other for the assignments,
Set the .multiselect property of the students list to simple,
Write VBA code in the assignments listbox .AfterUpdate event
which reads the students listbox, row by row, determines if the
student is or is not selected, and creates an insert query for
the student/assignment, executes the query, and loops to the
next selected student.
pseudo code example:
For each assignee in lstStudents.itemsSelected
strSQL = "Insert into StudentsAssignments"
& " (StudentID, AssignmentID)"
& "(" & lstStudents(column1,assignee)
& "," lstAssignments & ");"
Check the help entries for listbox, , specifically the
ItemsSelected and column() properties of
Dave White < XXXX@XXXXX.COM > wrote in
PA is y I've altered my email address.
Posted via a free Usenet account from http://www.yqcomputer.com/