Two things here...
First: Error 2465 seems to stem from access being unable to find a specified record. This could be caused if you are trying to use recalc on an unbound control and it is looking for a control source. For now I would comment out (using ' ) the recalc line for now.
Second: If I am reading this right EndDate is a text box and is triggering the query to should update the form and the total. You might try moving the requery code to the
Lost Focus event of the text box to ensure it triggers when the control looses focus. Additionally, if your still having trouble try changing the recalc to Me!Weekly_Ace_Order!Form!Text10.Requery in the same event. This should do it.
My apologies for not being able to pin down an answer, but sub forms react differently sometimes and I don't use them often. So, give this a shot and I'll keep working on it on my end.
Hope this helps.
- Minion -
This is what is in the afterupdate eventPrivate Sub EndDate_AfterUpdate()
Me.Weekly_Ace_Order.Form.Requery
Me!Weekly_Ace_Order!Form!Text10.Recalc
End Sub
The first line requerys the subform but the total on the footer doesn't update until i click somewhere on the form. I added the second line and get the error.
text10 is the control in the footer that totals the subform
Any thoughts