updating a table as soon as info is entered into a forms field

  • Thread starter Thread starter bfreeman
  • Start date Start date
B

bfreeman

Peps,

I need to update my tables as soon as information is added to eac
field in a form. I would guess it would have to be some global cod
that would refresh everything. Can anyone help?

My best,

Free
 
Why on earth would you want to do that? That means that you'd have to
create even more code to allow people to set out of the form without making
changes! Even then they'd have to remember what the original data was and
re-enter it. Access's default operations for forms are already pretty
powerful and intuitive. However, your purposes are yours so ....

In the AfterUpdate event of the relevant text boxes put

Docmd.acSaveRecord

HTH
 
Back
Top