Members and payments are to be in different tables, yes?
There are no doubt several ways to handle this. Simplest is having a checkbox field to identify their status, such as "Active". Your queries/forms only show those who are.
Or make Active (or Inactive) a date field. If no date (null) same as the unchecked checkbox field but now you have a date for when they became that.
Or have a field "Status" for when it is not a simple Y/N or Date/Null thing but is one of many possible values.
Whatever you do, don't move records around from one table to another and back again. It's very clunky and not necessary.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.