Looking back at my original post, I realize that I need to go into more
depth
to explain how my forms/subforms work. I now know the reason why this
must
not be working, but I'm not sure how it can be fixed.
I have a mainform, frmBid, which has a subform, BidLineItemSubfrom2, which
is
INVISIBLE. I'll explain the reason for this shortly. Also on frmBid is a
command button, which opens up another mainform called frmBidItems. This
contains a subform called frmQryBidLineItems, which contains the subform
called BidLineItemSubfrom2. This is the path and location where users
update
records.
So...I couldn't get the controls on frmBid to reference a subform located
on
a different form. My fix was to insert BidLineItemSubfrom2 as a subform
into
frmBid, but leave it Visible=No so that the records would exist within
that
form. I made it visible and deleted on record, and sure enough, the
calculated controls updated imediately and as desired.
Having just the subform on frmBid appears to be the root of the problem.
If there was a way to get those controls to calculate without requiring
the
invisible subform, that would be my ultimate solution!
Sorry for not fully explaining my form layout.
If you can still offer help, I'll greatly appreciate it!
Slez
Damon said:
Lets back up a bit - if you have code similar to this in a textbox (here
called UnitsOnHand) in the subform's footer:
=Sum(nz([Dollars],0))
then a textbox on the main form should have this:
=nz([subfrmYourFormName].[Form]![UnitsOnHand],0)
and it will change automatically when records are added or deleted, no
need
for any code.
There is a link between the main and subform, right?
Damon
Thanks for your reply! It works...sort of...
It works perfectly if existing records are altered or new records are
[quoted text clipped - 18 lines]
Thanks in advance for any help!
Slez