With this -
.RowSource = entity1
.RowSource = entity2 'you just changed the rowsource from entity1 with entity2
.RowSource = entity3 'you just changed the rowsource from entity2 with entity3
.RowSource = entity4 'you get the idea
.RowSource = entity5 ' :)
all you are doing is replacing the...