Hello All,
I'm brand new to this forum, so please be gentle if I'm asking a dumb question. I have a large access database (access 2010) where I often need to programmatically modify values for fields on the current form. I've tried modifying the control on the form directly through code, and this works but often triggers a write conflict error (another user has modified) when I move off the record. I think I've also tried update queries (modifying the underlying dataset directly rather than through the form). Worse than the error message, if I choose to overwrite it appears to corrupt the database! What's the right way to do this?
Thanks,
Doug