Creating records

[Daryl2106]

Hi Everyone,



I am a novice building a data base to manage student data. Thaks to this forum I have made significant progress in the database and my understanding of Access.

My next challenge/task is to create a way to record weekly attendance. I have looked at several databases available online but not that really reflect what I need. Also I am trying to do it the simpliest way possible (for now) with my limited knowledge of VBA code.

Here is what I am hoping to do. I have a form linked to a query that will select the students assigned to a faculty member in all the courses that faculty teaches. I would then like to be able to use the same form, and a second combo box, to create records in an AttendanceTable that stores the attendance for that student in that course for that week. I have created a key using StudentID-CourseID to identify each student with each of the course they are enrolled in. It is also used to relate all the involved tables.

Any direction/suggestion would be greatly appreciated.

Take care,

Daryl

Daryl

[animaimmortale]

It help if you cleared the data out of the database, zipped it and posted it as an attachment.

Taking a stab in the dark I would say you have to create a sub form on your courses form.

[Daryl2106]

Yes. I was able to use a subform and achieve what I wanted to do!

Thanks for your reply.

Take care,

Daryl