Attendance Form - Need to auto update names and dates

[Surfette]

Greetings,

I'm trying to create an attendance form for my school. I have an Attendance Form already that has the following information:

Student Name
Date of Attendance
Attendance Code

What I would like it to do is, automatically populate the date for all the students enrolled in the class. So if the Math class has 5 students, the form would automatically have all five students with March 28, 2006 and the next day have March 29, 2006 and so forth.

Any suggestions on how to go about achieving this task?

Many thanks in advance!
Surfette

 

[Laoujin]

You can set a filter on a form using Me.Filter = "[Date of Attendance]='01-01-2006'" this would limit the form to all attendance with date 01/01/2006.
You can filter on multiple fields like Me.Filter = "[Date of Attendance]='01-01-2006' AND [Attendance Code]='Math Class'"

You can also change the display of a form to be a "Continious Form" which would list all 5 students on the same page instead of having 5 results in your recordset.

 

[Surfette]

Hi Laoujin,

Thank you for getting back to me within minutes!

I have a couple of questions.

(1) Where do you set the filter on the Form?
(2) What does the "Me" in Me.Filter = .... mean?
(3) Does the Continous Form populate the student names over and over again for me?

Surfette