Auto Update txtBox

[fenhow]

Hi, I have a form that has a subform with a SUM in the footer of the subform.

I have a button that takes the SUM value and writes it to an unbound txtbox called lockedvalue

When I am in record 1 on the form, and click the button it does as it should with the SUM from the subform in record 1.

The issue I am having is when I go to record 2 and update with the botton, it takes the SUM from record 2 subform and puts it in lockedvalue but when I go back to record 1 it has the value of record 2?

How do I update the lockedvalue txtbox per record I am on so it sticks with each record?

Thanks.
Fen

 

[JHB]

Set the controlsource for the unbound control to the control with sum in your subform.

 

[arnelgp]

if your subform is a continuous form, it is not possible.

 

[JHB]

if your subform is a continuous form, it is not possible.

Why is that not possible, can you clarify?