If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tracking user changes - Part 2
I posted this already, but think I lost it; my apologies if it shows up
twice. Rick's suggestions about tracking changes in my form worked perfectly, except that changes to the subform don't trigger the update to the timestamp field (coded as a beforeupdate event on the main form). What's the best way to update a field in the main form based on a change to a field in a subform? As always, TIA. |
#2
|
|||
|
|||
Use the AfterUpdate event of the subform to update the field in the main
form, and save the change: Private Sub Form_AfterUpdate() With Me.Parent ![NameOfYourDateTimeField] = Now() .Dirty = False End With End Sub -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Carol Giannini" wrote in message ... I posted this already, but think I lost it; my apologies if it shows up twice. Rick's suggestions about tracking changes in my form worked perfectly, except that changes to the subform don't trigger the update to the timestamp field (coded as a beforeupdate event on the main form). What's the best way to update a field in the main form based on a change to a field in a subform? As always, TIA. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why does access security does not work under a different user acc. | Alfons | General Discussion | 6 | October 15th, 2004 04:53 PM |
Security: User Account Problems | David Kistner | New Users | 5 | October 14th, 2004 10:22 PM |
Update Part# field where is blank | JUAN | Running & Setting Up Queries | 4 | August 19th, 2004 08:54 PM |