G
Guest
I have a main form that has a beginning date field and an ending date field
(and various other fields) and is used for entering in master contracts.
Then I have a subform that is used for entering in sub contracts linked to
the master contract. In the subform I have begining and ending date
fields(and various other fields). The user will enter a series of sub
contracts in the subform with various beginning and ending dates. Once the
user is done entering the sub contracts I need the most recent beginning date
and the latest ending date (which they may not be entered in in that order)
to automatically fill in the master contract beginning date field and ending
date field. Any ideas??
Thanks!
(and various other fields) and is used for entering in master contracts.
Then I have a subform that is used for entering in sub contracts linked to
the master contract. In the subform I have begining and ending date
fields(and various other fields). The user will enter a series of sub
contracts in the subform with various beginning and ending dates. Once the
user is done entering the sub contracts I need the most recent beginning date
and the latest ending date (which they may not be entered in in that order)
to automatically fill in the master contract beginning date field and ending
date field. Any ideas??
Thanks!