From: Amy E. Baggott on
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