Add checkboxs to form to speed edit through records PLEASE HELP!

[masrymostafa]

I am designing a database in Microsoft Access that is designed to help with a small school program. So I have a table which includes all the student info (first name, last name, phone number and Class number) and I made a form (with a tabular format) which includes only the First name, last name, and Class Fields. I want to make this form to be used so that the teacher can use a check box beside each name and add them all to a certain class with a button. This is so that it is much easier than changing the class for each and every student.



THANKS!

[June7]

This can probably be done with an INSERT SELECT sql action. The real trick is making sure the action isn't repeated and duplicate records created so would need to clear the checkbox fields immediately after the INSERT SELECT. That will require an UPDATE sql action.

I use only VBA so following examples are for VBA to execute sql actions.

The INSERT SELECT could be like:

CurrentDb.Execute "INSERT INTO tablename(ClassID, StudentID) SELECT " & Me.ClassID & " As CID, StudentID FROM Students WHERE checkfield=True;"

The UPDATE could be like:

CurrentDb.Execute "UPDATE Students SET checkfield = False;"

Now what event will trigger this code - perhaps a button Click.