Form Laout - Matrix (row Heading, Colum Heading)

Hi all, this is my first post.


i have created a simple access database for keeping student and attendance record.

student table fileds are:

studentId - primary key
forname
surename
dob
gender
accademic year

attendance table fields:

studentid - primary key
date - primary key
attendance (yes/no boolean field)
paid (yes/no boolean filed)

this database is just ment to keep records of students attending at particualr dates.

for example if attendance table cotain records like:

http://www.crazyanime.pwp.blueyonder.co.uk/table.JPG

for the form layout, what i want to do is

http://www.crazyanime.pwp.blueyonder.co.uk/form.JPG

i want this to be editable. how would i do this using access form, or do i have to wrtite VBA code

PLUS i want the form to automatially have new records when i add for example a student, with ID 10011 OR if i add new records for a different date say 11/11/2006, then i want that to be viewd on the form just like the 21/09/2006 and the 04/11/2006.

please help :) been looking for a solution for long time.

thanks