Last date on subform

[Chalkie42]

Hi Folks. Should be simple enough, but I'm going cross-eyed researching this:

I've got a main form that displays records of individuals (selected from a combo box) Part of the data requires that I store 'from' and 'to' dates and as I need to keep a history as new periods are entered, I am using a sub form.

So far-so good. Thing is, I need several of these subforms and in order to de-clutter the form have hidden them and show them via a button. What I want to do is show only the most recent 'to' date in a textbox on the main form so that the user can decide whether to update the subform.

Your assistance would be most gratefully appreciated.

Chalkie.

 

[ajetrumpet]

Get the most recent date of a field by using this for the CS of the textbox:

=MAX(TheControlNameRepresentingTheField)

 

[Chalkie42]

Thanks Adam, I was convinced it was simple.