Access Front End with SQL Back End, Commit record changes
Posted on 2013-05-29
I have linked my SQL tables to the Access Front End using DSN-less. Now I am having an issue with getting SQL to commit record changes. One would think that when you move from one record to the next the change would be committed. And, that might be the case. However, I have a computed field in the SQL table (price*quantity) I created a text box that points to that field in the form. If I change the either the price or the quantity, the computed field does not change. I can move to other records. I can change other records. The field value does not change in any of the records. However, if I close the form and open it, all changes are accepted, recorded and the computed field is correct. Anyone have an idea why this is happening and what I can do to correct the error. I believe I could use the "dirty" function to write the change. However, there are some "before update" events that would get fired by this and I would have to modify those.