I am wondering if anyone could tell me how to accomplish the following. It is a problem I have been wrestling with for days now.
I have a form with several subforms. Each subform has a different default value for time of day and then fields for data collected at that time, with default values of zero. The main form has data including the date and student name, which are linked to the subforms so they will fill in their data automatically.
When someone enters a day's data, some times of day will have data exactly like the default values (zero) and some times will have different numbers entered in. When people enter data, it saves without problem. However, when the data is the same as the default values, (and nothing gets typed in), it won't save the data. I understand that access doesn't recognize this as a new record because it hasn't been dirtied until someone types in it. I would like it to recogize a new record in the subform as soon as the date and student name fields are entered on the mainform (and the subform through the parent child links).
My attempt to get around this have not worked. Has anyone got an idea?
Thanks in advance,
Carly
I have a form with several subforms. Each subform has a different default value for time of day and then fields for data collected at that time, with default values of zero. The main form has data including the date and student name, which are linked to the subforms so they will fill in their data automatically.
When someone enters a day's data, some times of day will have data exactly like the default values (zero) and some times will have different numbers entered in. When people enter data, it saves without problem. However, when the data is the same as the default values, (and nothing gets typed in), it won't save the data. I understand that access doesn't recognize this as a new record because it hasn't been dirtied until someone types in it. I would like it to recogize a new record in the subform as soon as the date and student name fields are entered on the mainform (and the subform through the parent child links).
My attempt to get around this have not worked. Has anyone got an idea?
Thanks in advance,
Carly