Split form value update

[Sparks54]

Hi all,
My data base consists of two tables linked on an ID field. The form is a split form with the datasheet at the bottom for the parent table. The child table is displayed on a subform of the main form. I have a calculated field in the subform footer that adds hours worked on a project and displays the value on the main form. That all works great, but the "hours worked" value in the datasheet at the bottom of the split form displays the "hours worked" value of the first project for all projects until the record pointer is moved manually in the data sheet. Then the right value is displayed in the data sheet. Is there a way to update the values on the "onopen" event of the form? I have tried looping through the records with "movenext" but the value does not update to the right value.
Any help would be great,
Thanks

 

[June7]

Don't think this calc 'delay' can be fixed. Suggest hiding the field/column in the datasheet part.

 

[missinglinq]

Suggest hiding the field/column in the datasheet part.

I think that's the only answer for this. You're dealing with an Unbound Control, and in Datasheet/Continuous View Forms, the Value of an Unbound Control in the Current Record is the Value of the Control in all Records!

Hiding the Control/Column, as June7 suggested, is easy:

Private Sub Form_Load()
  Me.YourControlName.ColumnHidden = True
End Sub

replacing YourControlName with the actual name of your Control/Column.

Linq ;0)>

 

[Sparks54]

Thanks guys