subform updates/refresh

[Lifeseeker]

Hi,

There are 3 subforms on my mainform in where users do updates. All the subforms are referenced by the Pk on the main form.

There is another unbound textbox on the main form that simply reminds users the PK they last updated on the main form, and it works great.

The code is: Me.Text91.DefaultValue = """" & Me.Fee_Num.Value & """"
where text91 is the unbound textbox.


Now I"m trying to add that reminder capability on the subform. So...if any subform has been updated(values added, values updated), I want the same unbound textbox to show the PK.

How should I reflect this? Is there an afterupdate event for the subform?

comment/help much appreciated

 

[jdraw]

I found this message online concerning identifying a control on a subform.
http://en.allexperts.com/q/Using-MS-Access-1440/Unbound-subform-textbox-control.htm
Hope it's useful to you.

One way to have Access write this syntax for you is to open a new query in design and place cursor in criteria cell, then right click mouse, select build, then forms, select mainform, then the subform, then the control. It's a good ideal to have your mainform open in design view, then you will see all in "Loaded Forms".
Bob Heifler
MyAccessProgram.com