Inserting OnCurrent into Expression Builder

J

Jennifer Cali

I have the following expression:
=[Forms]![frmEventSetup]![Audio-Visual].[Form]![AVSumBudget]

In the expression builder, I see that in the third column there are <value>
fields that looks as if I could use the OnCurrent within my expression. I'm
not sure where it would fit in, though.

The issue I'm having is that I have two subforms (sfrmAV & sfrmTotals) on
one main form (frmEventSetup). The first subform (sfrmAV) has the field
[AVSumBudget]. This field resides in the footer and is the sum of the many AV
Budget values. I need this value to pull over to the second subform,
sfrmTotals. It currently is with the formula I posted above, but when I
scroll through records it isn't always updating with the sum for the
CURRENTLY displayed record...it's always one record behind. I need it to
update to show the CURRENTLY displayed record. Again, I think I do this
somewhere in the expression builder as the third column shows OnCurrent but I
don't know where in my expression it goes.

Any help is greatly appreciated!!!
 
D

Damian S

Hi Jennifer,

In the On Current event of your form, select [Event Procedure] then click
the three dots.

In the event procedure that opens, type me.recalc to get it to force a
refresh.

Damian.
 
J

Jennifer Cali

Hi Damian,
If I enter your code into the OnCurrent of the main form, it will update the
field that the focus is on - but only that field. It won't update the other
two fields. For example, if the curser is in the AVSumBudget field, it will
update but ScenicSumBudget and LightingSumBudget become (and remain) blank.

--
Thank you! - Jennifer


Damian S said:
Hi Jennifer,

In the On Current event of your form, select [Event Procedure] then click
the three dots.

In the event procedure that opens, type me.recalc to get it to force a
refresh.

Damian.

Jennifer Cali said:
I have the following expression:
=[Forms]![frmEventSetup]![Audio-Visual].[Form]![AVSumBudget]

In the expression builder, I see that in the third column there are <value>
fields that looks as if I could use the OnCurrent within my expression. I'm
not sure where it would fit in, though.

The issue I'm having is that I have two subforms (sfrmAV & sfrmTotals) on
one main form (frmEventSetup). The first subform (sfrmAV) has the field
[AVSumBudget]. This field resides in the footer and is the sum of the many AV
Budget values. I need this value to pull over to the second subform,
sfrmTotals. It currently is with the formula I posted above, but when I
scroll through records it isn't always updating with the sum for the
CURRENTLY displayed record...it's always one record behind. I need it to
update to show the CURRENTLY displayed record. Again, I think I do this
somewhere in the expression builder as the third column shows OnCurrent but I
don't know where in my expression it goes.

Any help is greatly appreciated!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top