Using multi select list box

[frys]

I have a database that tracks peoples attendance in classes. I have 3 tables

1 Class
2 student
3 Attendance

I have to track between 30 and 40 people each class. i currently have a form to input the class and the description of the class. i then have a subform that tracks the students in the class.

right now i have a combo box that has the sudents names listed i choose a name and the box closes the name is generated into the attendance record. what i would like to be able to do is select all 30 people that attened a class and have access gererate the records for each of those students.

is this possible

thanks

chris

[PianoMan64]

Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, or if you want to send me a copy of what you have with some example data, that would even be better.


Hope that helps,

Joe P.

[frys]

Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, or if you want to send me a copy of what you have with some example data, that would even be better.


Hope that helps,

Joe P.

Joe i would love to send you a test copy of what i am working on can you send me a e mail to ** email address removed as per site rules ** so i can attach it for you

[aprpillai]

In the meantime have a look at this. Some additional help can go a long way

http://www.msaccesstips.com/2008/05/selected-list-box-items-and-dynamic.shtml

Creates a Dynamic Query using selected items from a List Box to filter records from an underlying table.

Regards,

[NeoPa]

Chris, Joe,

If you must converse directly, please exchange your details via the PM system provided. We remove all private contact details in threads for your own protection (as per the rules).

In fact, we really prefer questions to be asked and answered in the threads, as that is the point of the site. It exists, not only to answer individual members' questions, but also to be a repository of answers that can be found by anyone.

There may develop requirements that make this more complicated, but this question certainly hasn't reached that point yet.

[frys]

sorry .. something went a little squirrelly with my account.. could you please help me out with this issue. The query is currently

Main Table: Course
Lists all course information

Sub Table: Attendance
Lists all attendees to each course

Attendance Table is showing all attendance based on Course

[NeoPa]

Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, ...

Hope that helps,

Joe P.

I suggest you provide the information requested (at least) before re-iterating your request for help.

You may want to consider clearing up the question too. I notice three tables mentioned in the first post. After a request for clarification and fuller information, you mention only two - and one of those is a new one.

PS. Here is a (copyable) example of how to provide table layout information.

Table Name=[[U]tblStudent[/U]]
[I]Field; Type; IndexInfo[/I]
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

[frys]

I hope this is what you are looking for me to show you.. If it is not i apologize and will attempt to give you the information needed to resolve my question

Table Name=[[U]ProgID[/U]]
[I]Field; Type; IndexInfo[/I]
ProgID; AutoNumber; PK
ProgName;String;FK
ProgDate;Date/Time
StaffID,Numeric

Table Name=[[U]StudentID[/U]]
[I]Field; Type; IndexInfo[/I]
StudentID; AutoNumber; PK
FirstName;String;FK
LastName;String;FK
ClassNumber;Numeric;

Table Name=[[U]AttendanceID[/U]]
[I]Field; Type; IndexInfo[/I]
AttendanceID;AutoNumber;PK
ProgID; Number; FK
StudentID; Number;FK
Notes;String

thanks for your help

[NeoPa]

That's a good example of what's required, but it seems like Joe has gone awol.

If you still need help with this then I'll step in and do what I can.