I have 6 combo boxes that are from a query
SCID
CID
ClassStartDate
ClassEndDate
Trainer
SID

What I would like to do is choose
SCID
CID
ClassStartDate
ClassEndDate
Trainer
These fields will be used to update SID (Student)

My goal is to be able to choose a new SID an requery and keep SCID, CID, ClassStartDate, ClassEndDate and Trainer the same.


OR

I would like to be able to create a roster per se and update the SCID, CID, ClassStartDate, ClassEndDate and Trainer at one time.

Could someone please help me with one of these options. Either one will work for me.

Thanks

Welcome to Utter Access!

I'm not real clear on your post. I assume the combo boxes are on a form. I'm guessing that SID is a student ID number and CID is a class ID of some sort. I'm not sure what SCID is. It sounds like you want to select SCID, CID, ClassStartDate, ClassEndDate and trainer and assign various students (SID) to the same class. You say you want to update but I think you will need an append query not an update query. What does your table structure look like?

You have it pretty right. My table structure. Please keep in mind I did not create this database, I am picking up on where someone left off.
Okay table structure what does that mean?

I have a table
Class that has
CID
Class
Provider
Hours
License ID

Then I have
Staff
SID
Which has their personal information

I also have a table Training
This has
SCID -Student Class ID
CID
SID
ClassStart
ClassEnd
Trainer

When I look at relationships Staff and training are joined by SID, and Training and Class are joined by CID

I hope this helps. If not let me know what other info I can provide you.

Thanks
Cheyenne

Table structure is exactly what you provided--the tables with their fields and how they are related. Let me ask a few questions that will help me understand your application a little better. You have a series of classes that various staff members have to take. Do those classes have multiple sessions? For example, let's say that class 1 is a 2 day course and you offer the course 3 times (or 3 sessions) per year. A staff member only has to take the course once, but they have a choice of sessions, is that correct?

No that is not correct

For example I will choose
Class Name
Start and End Date
and the trainer

I then will choose the student. I want to click a command button and the above info will add to the student. I then want to be able to choose another student without rechoosing the above info again.
I attached a screen shot. However the layout does not need to stay the same. I can move it around and such.

You might want to check out this post it sounds very much along the same lines and there are some example databases that might help you structure your tables properly and set up your forms to do what you want.

I looked at it and it does not help me. The attachement I sent you is what I am looking for however when I have it requery it of course goes back to the start. Is there any way to be able to just change the name and leave the top combo boxes the same?

Thanks for your time

The attachment you provided does not help since I cannot see the code and on what event it is firing. Can you zip and attach a copy of your database (with any sensative data removed, of course) and then we can take a look at it?