Recent content by LucyF

Sorry, I am not trying to make things more confusing, I was actually trying to make things clearer. Please don't waste any more time on my problem - I *really* appreciate your help so far but I don't seem to be able to explain clearly what I need it to do ... I'll keep working on it & I'm sure...

Thanks for your help Rainlover & Minty I will go & play around with events a little more - maybe I can work out a way of doing what I need it to do. I know I can make it work, but I guess I'm not explaining very well here what I'm trying to do :) Thanks for your help, I *really* appreciate it!

I have no problem with how the master form/table updates. That is absolutely fine - I do NOT need help with that! Pic 2 shows the "properties" of the field "status" which is a bound control/field on the master form - after update it updates the "updated" field correctly Pic 1 shows the command...

sorry - yes, bound controls on the main form have the "after update" event set to update the "lastupdated" field to Date() If I change an entry on the master form, it updates the "lastupdated" field as expected However when I add a new entry to the subform it doesn't update the "lastupdated"...

On the parent/Master form, the sub fields have an "After update" event which sets the field "LastUpdated" to Date() I need to also update this same field whenever an entry is added to the sub-form/linked table I tried the following in both the "after insert" and "after update" fields on the...

Parent form/table, with a subform (separate table, 1:M link on "ID") The parent form data stays fairly constant (occasional change/update), with multiple entries in the subform for each parent record which are added to more frequently The master table has a field "last interaction" which I need...