Bulk data entry & resetting form

terrytek

Registered User.
Local time
Today, 15:47
Joined
Aug 12, 2016
Messages
75
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.
 

Attachments

using a tHours table,
studentID, ClassID, Date, Hrs

using the master form of the Class. the subform would show the list of dates.
drilldown by selecting a ClassDate, click a dataEntry button,
this would open a form for That Day, That class, with a list of students,
enter hours for each.

or
in a form, select cbobox Class, and cboBox ClassDate
click HrsEntry button, to open form of students to enter hours.
 
using a tHours table,
studentID, ClassID, Date, Hrs

using the master form of the Class. the subform would show the list of dates.
drilldown by selecting a ClassDate, click a dataEntry button,
this would open a form for That Day, That class, with a list of students,
enter hours for each.

or
in a form, select cbobox Class, and cboBox ClassDate
click HrsEntry button, to open form of students to enter hours.

Not sure what you mean by drilldown by selecting ClassDate; the date can be any date; would not likely be a date already in the table?

For the second method, what would I use as the record source for the form I would be opening?
 
Here is what I did :
Made a query who will reset all the records in the table.
You keep all the lines in that table but you can enter new dates again.
The old dates are lost. So I don't know if you want to keep them or not.
 

Attachments

Users who are viewing this thread

Back
Top Bottom