I hope this makes sense...

My frmEmployeeMain contains one subform, frmProbation. Within frmProbation,
there are three subforms, frmProb1, frmProb2, frmProb3. Each of these three
subforms has a CompletionDate field. These three subforms were created by
three queries from ONE table, tblProbation.

The frmEmployeeMain was created from tblEmployeeInfo. In tblEmployeeInfo and
frmEmployeeMain, there is a LastReportReceived field.

The EmployeeID is the related record in all these forms and tables.

Is it possible to automatically populate the LastReportReceived field with
the most current date entered in any of the three Prob subforms, and also
allow the LastReportReceived field to be edited?