Auto save after data entry?

  • Thread starter Thread starter mlkiser via AccessMonster.com
  • Start date Start date
M

mlkiser via AccessMonster.com

I created a form. The user will be entering multiple types of data. Not all
the data will be filled in each time. What I would like to do is have
anything they enter written to the table as soon as they move out of that
item. I know I could do an AfterUpdate for each item and use me.dirty to do
it. But what I am wondering is, is it possible to not have to do VB code for
each data item? In other words, is there a way to say "after anything changes
on the form, update?" Or do you have to go one item at a time? Thanks.
 
Not a good idea for performance, particularly if you have serveral users on
the database; however, the Me.Dirty = False in the After Update event of each
control is the most straightforward way to do this.
 
Back
Top