Search results

I figured it out. I used a Macro to run versions of the two queries the first poster suggested and that worked.

Yes you could inactivate all the records from the student and classes form that have that classID, but I don't want the user to have to do this manually. I don't want to delete any records. Ok so I need help on the WHERE part. It doesn't like just Inactive. Or if I put the form and then the...

Opps I meant Inactive = -1

Could I use the below SQL? UPDATE Students SET Enrolled = 0, WHERE Inactive = 1;

The user enters students in a class form with a subform where there is a combo box and list all the students that they entered from a different form. The user is able to enroll each student in future classes (to hold their spots, preschool). I have the user check the enrolled box (this also...

Yes, I do know that already and have tried to put code in to make enrolled = 0 from the students table, but I'm not doing it right. Thanks for helping me. I need the code to do this or if I can do it with queries I'm unsure on how to do this in the afterupdate event. Thanks again.

Ok smarta**, How do I do it then if you are so smart? I can make the queries like the above poster stated but then how do I get those queries to run when the user checks the check box to inactivate the class.

Is there anyway to do this from the Class Inactive form (this form just shows the classes, so it only has class information)? I don't want the user to have to go anywhere else. I just want them to be able to inactivated the class and then automatically (by running code I'm guessing) inactivate...

Hi: I have two tables Students and Classes that are joined together by a inner table Student And Class (many to many relationship). I want the user to be able to check a check box called Inactive in the Class table to deactivate a class once this happens I want the check box called enrolled...