I need to have a form that shows a list of students sorted by class and allows me to enter hours and a date for each student, i.e. the list of the students would be in datasheet-like view, with empty fields next to each student for DateReported and Hours. Then I would click a command button and the form would "reset" so that the DateReported and Hours fields are blank once more to receive new data.
I have attached a stripped and simplified example of the relevant objects in my db. The form works great the first time you enter data, but how do I get it to appear the same way the second time, i.e. with a list of students by class and empty DateReported and Hours fields? If I set the form to Data Entry>Yes, of course all of the fields are empty when you open the form; I only want the DateReported and Hours fields empty. I tried adding some code to the command button to set the fields to null, but that (a) only resets the fields in the first record in continuous view; I want all the records reset and (b) deletes the data in tblClassHours, which I absolutely don't want.
Thanks.
I have attached a stripped and simplified example of the relevant objects in my db. The form works great the first time you enter data, but how do I get it to appear the same way the second time, i.e. with a list of students by class and empty DateReported and Hours fields? If I set the form to Data Entry>Yes, of course all of the fields are empty when you open the form; I only want the DateReported and Hours fields empty. I tried adding some code to the command button to set the fields to null, but that (a) only resets the fields in the first record in continuous view; I want all the records reset and (b) deletes the data in tblClassHours, which I absolutely don't want.
Thanks.