Table update on lost focus in subform

  • Thread starter Thread starter Luke
  • Start date Start date
L

Luke

Hello -

I have a field on a subform that is tied to a table and a
button that does some calculations once a number is
entered into the field (within the same record).

If I enter a number and click on another record in the
subform, the underlying table seems to update ... then, I
can click on the button associated with that record to get
the calculation to work. If I enter a number and click
directly on the button, it uses the old value in the table
for that record.

A LostFocus event procedure seems the way to go, but what
VB command do I use to get the table to update immediately
with the value in the form buffer when that field loses
focus? It loses focus the instant the button sitting right
next to it is clicked for the calculation.

Thanks for any help,

Luke
 
Back
Top