Thanks KenHigg for your speedy reply
The On_Exit event works, but I have to select the field and then move off it (Exit) for the event to trigger (which is what it is designed to do).
The Calculated field updates instantly when I enter data in the subform and I wanted to update the Table Field in the same way. Had it working OK in ObjectPal but it's time to move on. Is there a way to automate it without user intervention?
Don't quite understand the 'Dirty' event.
The bit of simple code I'm using is as follows:
Private Sub TotalJobList_Exit(Cancel As Integer)
Dim TJL As Control
Dim TJ As Control
Set TJ = Me.TotalJob
Set TJL = Me.TotalJobList
TJ = TJL
MsgBox ("TJ Value " & TJ)
hope you can help