I have a form based on on a query with an aggregate so obviously I cannot update/save any data on this form. There is only one field on this form that may need to be changed. So I wrote a simple update query that will run when that field loses focus. Easy enough. Of course, the form is now considered dirty and if I attempt to exit it will try to save and error out as you would expect.
In my code, I put an undo after I run my simple update query. Here's my problem. The undo works fine, but the field I have just updated reverts to its original value even though the update occured successfully. If I close and reopen the form, the new value will be displayed correctly. Is there anything I can do to prevent this?
TIA
Craig
In my code, I put an undo after I run my simple update query. Here's my problem. The undo works fine, but the field I have just updated reverts to its original value even though the update occured successfully. If I close and reopen the form, the new value will be displayed correctly. Is there anything I can do to prevent this?
TIA
Craig
