EleanorG
11-14-2001, 11:39 AM
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
11-14-2001, 04:58 PM
On the main form BeforeUpdate event put:
Me.MainFormDate = now()
On the subform BeforeUpdate Event put:
Forms!MainFormName.MainFormDate = Now()
HTH
EleanorG
11-15-2001, 06:53 AM
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
11-15-2001, 05:00 PM
THANK YOU - I am not very good at this but with your help it is working now - you are wonderful