It sounds like you need a trigger on each page that selects the max date appropriate to each page when each page is selected. The trigger may also require other selections to be cleared, but possibly not, depending on your model. Go to the properties on each page and create a trigger to Select in Field and select the appropriate date field, then make that selection =Max(appropriate date field). If you need the other selections cleared create another trigger that clears other fields.
