Search results for query: *

I GOT IT! Awesome! Thanks guys - for helping me think this through and checking where I put the code(s). It looks like I put it in the main form and not in the Sub-form - big difference there. I'll come back with other stumping issues as I finish this one project and start the next one...

I'm sorry, I don't think I know what you mean - the call to the SubSum() function? I'm guessing here you mean did I put in the subform the unbound textbox and it's control source is =subsum() and on the afterupdate event is DoEvents Me.Recalc?? During and after I composed this reply, I...

Here's what I have under the modRunSum (code) Option Explicit Public Function frmRunSum(frm As Form, pkName As String, sumName As String) Dim rst As DAO.Recordset, fld As Field, subTotal Set rst = frm.RecordsetClone Set fld = rst(sumName) 'Set starting point. rst.FindFirst "[" & pkName & "]...

I'm sorry for not being clear. I was referring to the FAQ702-5248. On this referred thread, next to last box, it says to put "in the details section of the form, add an unbound textbox. Set the Control Source to CODE =SubSum()" So that is what I was referring to in my message. It's a...

thread702-1048752 Hi, I've been trying unsuccessfuly to get this to work. In a subform, I have followed these directions and looked it over and over, yet still get the "#name?" value displayed in the Total field. It's not the "#error" as mentioned in another thread on a similar subject. Any...