Update Date Field on Main Form when Changing Info in Sub Form

[avaffa]

I have a form that contains a sub form. The "Last_Update" field is automatically updated with the current date on the main form whenever I change info in a record. I did this by using the following code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
LAST_UPDATE = Date
End Sub

Whenever I change info in the sub form, the "Last_Update" field on the main form is not updated. How can I get the "Last_Update" field to display the current date on the main form whenever I change info on the main form AND sub form? Thanks!

 

[scriverb]

In the AfterUpdate Event Procedure of the SubForm you can put the following code:

Forms![MainFormName]![Last_Update] = Date()

Referring to controls from a Main Form to a subForm and visaversa can be confusing. Please refer to the explaination in this link to assist you in this type of VBA code:

http://www.mvps.org/access/forms/frm0031.htm

Let me know how this works for you. Bob Scriver

 

[avaffa]

The link to the VBA code helped a lot. Thanks!

 

[bphillips]

I followed the above steps, but the date will not appear in the date field on the main form. Do I have to refresh the field somehow?

 

[scriverb]

You might try a refresh or repaint to get the control to display.

Forms![MainFormName]![Last_Update].repaint
Bob Scriver