Hi,

I'm working with Access 2007 at the advanced beginner/very low intermediate level. I know how to do all the things I will be asking separately, but I'm not sure how put them together into a smooth process. I'm hoping someone will be able to help me.

Based on the excellent tutorials at fontstuff, I was able to create a multiple parameter query form for my educational database. The four main fields I want to query on are Year, Status (active or inactive), School and Grade. The form lists all the parameters in list boxes and I am able to use And/Or operators in between the list boxes to further refine my query.

However, I need to take this to the next level. Due to my user's needs I have to find a way to select the students I want, using the query tool I just mentioned and enroll them into services. This is necessary because 700 students might need to be enrolled in one service, and it would take a ton of time to go through each individual record and enroll them. What I want is for the users to be able to query let's say all active students, and enroll them in a given service.

I know that would involve creating a new record in both the service table, and the student service table (a junction table that has both the StudentID and ServiceID). I would have to fill in the service name, date, category, etc. and then enroll the students. I just have no idea how I'd do that. Would anyone be able to point me in the right direction? Thank you!