Update another field

[kevin19]

Hi all!
I have a subform with a notes field. Upon creating a new note in the subform, I like to update a Date field in the main form to today. The date field consists of an old date which needs to be automatically updated upon creating the new note.
How can one do this? Anyone help please???
Thanks!

 

[pr2-eugin]

Try the Sub form's Before Update event, test if it is a New record update the fields of the mainform.. Something along the lines of..

Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Me.NewRecord Then Me.Parent![COLOR=Blue]dateControlName[/COLOR] = Date
End Sub

 

[kevin19]

Thanks for your prompt response!
Tried it but afraid it is not working....I am using MS Access 2007.
??

 

[pr2-eugin]

Is the control in the form being set in the first place? Try some debugging and see if they work..

 

[kevin19]

the date is set in the control source. I just need to automatically change this date to today's date once I have edited or created a new record from the subform. The date is in the main form.
Thanks!