Hi Mike,
you can update the database wherever you like, and after what-ever event best works for you. I guess the problem boils down to;
a) find the right embed point.
b) write the record.
I recommend using the various DebugView settings to see what evernt are firing, and what handlers are being called etc. That should make part (a) straight-forward enough. (If not then ask in the user group and we'll cover the technique.)
For (b) the important thing to note is that the file is problem not open, and the record to update is not loaded. So you need to do it all;
Access:table.Open()
Access:table.UseFile()
tab:Guid = p_web.GSV('tab:guid')
Access:table.Fetch(tab:GuidKey)
tab:something = p_web.GSV('something')
Access:Table.TryUpdate()
Access:Table.Close()
Cheers
Bruce