Feb 13 2009, 01:08 PM
I have 6 combo boxes that are from a query
What I would like to do is choose
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.
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.
Feb 13 2009, 04:27 PM
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?
Feb 13 2009, 04:55 PM
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
Then I have
Which has their personal information
I also have a table Training
SCID -Student Class ID
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.
Feb 13 2009, 07:43 PM
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?
Feb 17 2009, 07:12 PM
No that is not correct
For example I will choose
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.
Feb 17 2009, 11:08 PM
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.
Feb 18 2009, 02:02 PM
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
Feb 18 2009, 02:12 PM
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?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here