tables update after text box enter

[mudster01]

HI All - i have a number of text boxes which user can change values, however on change of value the bound table does not update until the form is exited.

How do i ensure the table updates regardless of exiting form or not?

Many thanks,
M

 

[RuralGuy]

You can put:

If Me.Dirty Then
   Me.Dirty = False
End If

in the AfterUpdate event of each TextBox.

 

[Pat Hartman]

Rather than forcing the record to be saved after each field is updated, add a save button to the form. In its click event place:

If Me.Dirty Then
    DoCmd.RunCommand acCmdSaveRecord
End If

Access automaticly saves the current record when you move the record pointer to a different record or when you close the form. If you want the user to have the option to save at other times, Use the save button.