Update data from a subform

[Trev]

I have a membership database that has a member form with
a membership details subform on it. The sub form has Date
& Membership Level fields
I need to display the Membership Level from the last
record from the linked membership details subform in a
field on the member form.
I am trying to use this to maintain a membership history;
Would it be possible to return this value for the current
membership year and possibly return "Non Financial
Member" if the membership is not current?
If there is a better way to do this I would appreciate
any suggestions.


Regards