Retrieving the most recent date in a recordset

[MDY]

I want to create a field in a form that searches the
recordset of a related table and returns the value of the
most recent date entered in a given field.

 

[fredg]

I want to create a field in a form that searches the
recordset of a related table and returns the value of the
most recent date entered in a given field.

In an unbound text control:
=DMax("[DateField]","TableName")