View Single Post
  #4  
Old April 30th, 2010, 05:51 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Form doesn't move to next record after update

If you are in the subform, the parent record has already been saved. If the
parent record is updated from the subform by an Update query or some such the
parent form would not be dirtied, so there would be nothing to gain by Me.
Parent.Dirty = False as far as I can see.

Daryl S wrote:
DT -

When you update the TS, are you updating the value on the main form, or are
you updating the database with a SQL update query?

If you are updating the value on the main form, then you need to save the
record. If you are on the subform, and you update the parent form field,
then you need to save the parent record. Me.Dirty=False works on the current
form, so if you are on the subform, that would try to save the subform, not
the parent form. You would want Me.Parent.Dirty=False.

If you are updating the value in the database, then the main form is out of
sync with the database, and you would need to requery the main form (not the
subform).

If you are still struggling, show us the code that updates the TS, and tell
us what errors / messages you get when you try to move records.

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

[quoted text clipped - 10 lines]

Thank you!


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