Table update on lost focus in subform

[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

 

[MacDermott]

You could try
Me.Dirty = False