Default Values for Multiple records on form

[rhenson76]

I want to have a form open with multiple records with default values for different students in my gradebook. They have daily grades that I want to have a form open with each student and the maximum possible for their grade for that day then I can change it if I want to or leave it as is. I have made a grades table with the StudentID as the related field. Is there a way to do this or am I dreaming?

Thanks, Rebecca

 

[kavarin]

When you say open a form with multiple records, do you mean you want every child in your class visible at once (or something like that) How are the default values calculated. Do you mean bring them forward from a previous day?

 

[rhenson76]

I want the form to contain a text box with the current date, and then I want a record for each of my studentID's and daily grade for the day. I have it set up to save to a Grades table with each record containing the fields GradeID(Autonumber), StudentID(related to Student table), Date, DailyGrade.
I want it to have one text box for the date that would apply to all and then say I have 10 students, I want to be able to enter daily grade for them all on the same form. I hope this is possible somehow but I haven't got a clue. The only way I can do it now is to enter each one individually. The default value would be 10 for DailyGrade and for StudentID I want it to come from my Students table.

Thanks for your help,
Rebecca

[This message has been edited by rhenson76 (edited 04-19-2002).]

 

[kavarin]

Are your studentID's assigned by you (last name, ssn#, etc) or are they autogenrated on entry?

 

[rhenson76]

They are assigned by me. Is this good or bad?



[This message has been edited by rhenson76 (edited 04-22-2002).]