Form/Subform Update Field

[EleanorG]

I would like to put an updated date field on either my main form [Title] or the subform [Status] that reflects any changes in EITHER..if I put it on the form it only reflects the form changes and on the subform only the subform changes...I know it goes on the beforeupdate...I don't know what I'm doing wrong

 

[jwindon]

On the main form BeforeUpdate event put:

Me.MainFormDate = now()

On the subform BeforeUpdate Event put:

Forms!MainFormName.MainFormDate = Now()


HTH

 

[EleanorG]

I must still be doing something wrong...I am getting a compile error

[This message has been edited by EleanorG (edited 11-15-2001).]

 

[EleanorG]

THANK YOU - I am not very good at this but with your help it is working now - you are wonderful