If you can't update the record there is a problem that probably won't be
solved by closing and reopening the form. If the form and subform are based
on queries, can you edit the query directly? If so, what is the code you are
using to update the TS field, and what event are you using to update it. If
it is the After Update event, it needs to be the After Update event for each
control, not for the form. The After Update event for the form occurs after
the record has been saved, so it can't be used to insert a value into the
record that was just updated. The form's Before Update event runs only when
the data in the record have been changed, so that is the place to update TS.

DT wrote:
I have a main form with lots of data and a "time-stamp" (TS) field. There is
a popup form with more data on it that is Parent-child linked to the main
form. When ANY field is modified (pop-up or main form), I have an
"After-update" event that updates the TS. My problem is that once the TS
update occurrs, I can't move to the next record. I first have to close the
form and open it again.

I've tried Me.Dirty=False on the forms, and it complains that it can't
update it. I also tried Me.Refresh. That doesn't seem to work either. I'll be
trying both again with more scenarios, but if someone has some experience
with this issue that they can enlighten me with, it would be extremely
helpful. I've wasted WAY to many hours on this seemingly simple issue... =\

Thank you!


--
Message posted via http://www.accessmonster.com