Problem with DB update in Access tabbed form
Posted on 2011-05-02
I have a very simple and very irritating problem: I have a data capture form with a number of tabs, each tab corresponds to one table in my database. One tab has only 3 fields on it, and all of these can be set either by a fixed default value or a default value which I fetch by VBA code from another table in the DB when the user clicks on that tab and that field is empty.
The problem with that tab is that, if the user does not change anything because the 3 fields contents are correct, Access does not store the field data in the database, unless one at least physically clicks in one of the fields. I've tried everything, using docmd.runcommand accmdsaverecord, me.dirty, even faking a click in one field by VBA code to force a save, but to no avail. Even though I set one of the fields with a value through VBA code, Access just doesn't insert a new row for that data. Tab change also doesn't help. I still need a real user interaction to get the data saved. However, I want the data to be saved even without user interaction. How do I do that ?
Thanks for help