10 But when that which is perfect is come, then that which is in part shall be done away.
11 When I was a child, I spake as a child, I understood as a child, I thought as a child: but when I became a man, I put away childish things.
12 For now we see through a glass, darkly; but then face to face: now I know in part; but then shall I know even as also I am known.
13 And now abideth faith, hope, charity, these three; but the greatest of these is charity.
King James Version (KJV)
It do not say prophecy cease when scripture come.
Logically speaking, scripture is the document of the teaching of Christ and what Christ did to anounce salvation, than apostle and Christians continue It.
Not only apostle and Christian, in act we read Holy spirit also did spread the gospel, Holy Spirit talk to Paul oN his way to persecute christians.
The teaching of Jesus is complete, yet He also prophecy
So your formula when the complete come, No more prophecy is not biblical at all