Create a roster like table

[Chey]

I have a form with the following info to be entered on it.
Class
Date taken
and some other stuff.

I put a combo box on my form to look up students names. I also added a
command button to add the student to the "roster" is what I am calling it. I
then want another command button that will take the above information (ie
class, date taken etc. and fill in the fields that each of the people have
taken that course.

Can someone help me on getting this accomplished?

Thanks

 

[Jeff Boyce]

"How" depends on "what". You've described a form, but not your underlying
data structure.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chey]

Okay I will try my best at this. It is some one elses construction I am just
fine tuning it.

After thinking about it, what I am really trying to do is on a form I will
have a subform. In this subform, I want a combo box that will filter the
information in another subform that is a table view. I have been trying this
but have been unsucessful. I then want an add button to add the info from the
main form into the sub sub form. So I will only have one person up at a time.

The history of what we are doing is when a person takes a class I only want
to enter the class information in 1 time, but it to apply to the persons I
have selected because they have take the class. If there is a better way to
do this then I am up for all suggestions.

So my underlying data structure. I have all my tables and queries
established, I just need the form constructed to utilize the tables and
queries.

Let me know what else I can provide.

 

[Jeff Boyce]

Chey

You described your forms and subforms again.

"How" to do what you asked about depends on "what" data you have underneath
the forms.

Here's a simplified approach to a data structure for keeping track of
classes folks sign up for. How does this compare with your data structure?

tblPerson
PersonID
FirstName
LastName
DateOfBirth

tblClass
ClassID
ClassTitle
ClassStartDate
ClassEndDate

trelEnrollment
EnrollmentID
PersonID
ClassID
EnrollmentDate

Regards

Jeff Boyce
Microsoft Office/Access MVP