You could use the .Requery property for the subform to refresh. The question is, do the users keep the form open all day? Or do they update it, close the db, and reopen when they need to update it again?
I think the problem might lie in the condition of the .Requery. If it is the former, there is no trigger event for the .Requery, such as opening another form and going back to the form with the subform on it (OnActivate). Perhaps adding the requery after the update of a record on the subform would do it or using the Timer event.
For the latter, I would guess that you haven't linked the subform master/child fields or set the relationship up correctly so the the links are updated on record creation.
HTH,
-dK
