on focus problem

  • Thread starter Thread starter anil
  • Start date Start date
A

anil

Hi all
I am using a form where in the subform I am doing total of the values
in the footer.
Since I want that total value in the main form in textbox.I have used
this sub on get focus as

Private Sub Totalwatertillnow_GotFocus()
Me.TotalWatertillnow = Me.frmCartingsubform1.Form.TotalVolume
End Sub

and the second one

Private Sub RemainingEntitlement_GotFocus()
Me.RemainingEntitlement = Me.TotalWaterEntitlement -
Me.TotalWatertillnow
End Sub

Now all works fine as I get value on gotfocus.problem is when I open
the form next day the textbox is empty,although it gets value when it
gotfocus.
Now is it possible that it gets the value on opening of form.I have
tried on open and on load but not successful.
Can you please suggest what can be done so that I always see the value
always and it updates if I change record.

Thanks
anil
 
Dear damian
Sorry it did nor work on current event also.
Actually it brings the data to 0 and I need to click there to get focus
and the data.
Can you recommend any other way.
Thanks
anil
 
Dear damian
Sorry it did nor work on current event also.
Actually it brings the data to 0 and I need to click there to get focus
and the data.
Can you recommend any other way.
Thanks
anil
 
Back
Top