I have a parent form named frmProject. There is a Total Time text box called txtTotalTime - the data control source does a DLookUp for a query that adds together time spent.
The subform on the Project Form is called frmProjectHistory. The default view of it is datasheet view.
I've tried setting the On Dirty event for frmProjectHistory to Me![frmProject].requery or Me![frmProject].[txtTotalTime].requery (or Forms! inplace of Me!). each time I get "can't find the object" followed by the Me!frmProject....
I'm needing to update the Total Time box on frmProject every time either a new record is entered in the subform datasheet view - or when time is adjusted for a previous event.