Prev: Pointing a specific line in a continuous form
Next: Getting 'Type mismatch' error after redesigning form
From: Amy E. Baggott on 23 Apr 2010 11:28 I have a form that contains three subforms (for order items, payments, and assigned booths). Each of these subforms contains a button that calls a form to use for adding or changing records to make it easier and more intuitive for the user to fill out and to catch user errors before they get saved into the record. Changes to the subforms trigger changes in the contents of calculated fields in the main form. I am trying to get the form to update "date modified" and "modified by" fields when any of the data on the main form or subforms changes so that we can see who the last person to change the data was and when they did it. Is there an easy way to do this, or do I have to go into all my "add" and "edit" forms and have the dates pushed from there? -- Amy E. Baggott "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson |