Recent content by spindip32

I figured something out. Turns out the link from mahenkj2 was helpful. I changed the record source of the subform to a SQL statement that included 'o_unit_price*o_qty as product_sub' in the select statement. I then put sum(product_sub) as the control source of the fldItemSum control. It works...

Mahenkj2, thanks for the reply. This doesn't quite solve my problem, though. I have read this article and my form is set up accordingly. I only have the subform in continuous view so that I can make sure that the calculated field in the subform footer works. My long-term plan is to use datasheet...

I am using Access2007 in XP (please don't judge). So, I have looked everywhere on the Internet. I have even been reading Access 2007 All-in-one for dummies. I think I have done everything right. I have a mainform (frmOrders) linked to a subform(sfrmOrderDetails). I have an unbound text box in...

Hello, I'm an American living in Wales. I am not totally new to Access. I've used a few programs designed in Access and even modified another programmers VBA code (got lucky). I am attempting to build an access database from scratch and learning about macros and VBA in the process. So, in...