Automatic information from subform

[Rothron]

I am designing a new database which will have a form and a subform (I am already having enough trouble trying to cope with subforms!). There is a field on the main form called "Date of last data change". Is there any way that the date something is changed on the subform can automatically be entered into this field?

Any help greatly appreciated as I am leaving in 2 weeks and have to complete the database by then.

Thanks

 

[Jack Cowley]

When exiting the last control of a record in the subform you could check the Dirty property (see Help) and if the record has been changed then something like:

[Forms]![MainFormName]![Date Of Last Change] = Date()

should work for you. It the subform contains more than one record you will need to let the Main form know which record was changed as well as the date it was changed....

HTH,
Jack

[This message has been edited by Jack Cowley (edited 10-06-2000).]