Hi
Not double posting but just moving a thread where it should have been started.
I have this update query that is triggered by an after update event on a main form. The record being updated are in a continuous subform. It works well except from the last added/modified record.
My tables are linked to Sharepoint lists. I suspect it has to do with some record lock but I don't know how to handle it.
Here is the original post: http://www.access-programmers.co.uk/forums/showthread.php?t=266172
Not double posting but just moving a thread where it should have been started.
I have this update query that is triggered by an after update event on a main form. The record being updated are in a continuous subform. It works well except from the last added/modified record.
My tables are linked to Sharepoint lists. I suspect it has to do with some record lock but I don't know how to handle it.
Here is the original post: http://www.access-programmers.co.uk/forums/showthread.php?t=266172