Only displaying latest record for each person

[Waterfly]

Hi

As requested, a fresh perspective on this.
See attached.

I've added a boolean field 'Active' to the tblMemberStatus and modified the query and subform to filter for Active=True

If you're happy with this idea, all you need to do is when members are added or changed is
a) set Active=True for the current membership type
b) set Active = False for any previous membership types

You could easily do both of these using VBA

Hi Ridders,

Thanks, I've taken this approach as it seems the easiest at the moment!

 

[isladogs]

You're welcome
Both approaches work.
In fact my first thought was to do exactly what jdraw posted