@Gasman....Thank you so much, it worked!
Well I did test it before posting.
However arnelgp gave you all that code and you were not able or did not want to work out what was wrong.?
That is how you will learn, by undestanding the code.
A lot of the code I have used came from the net and then was modified to suit my purpose. In doing so I slowly understand more and more, slowly being the operative word.
The link that theDBguy posted did it a slightly different way, but should work as it is, once you change the names to suit. However again, you need to understand the code.?
Anyway hopefully you can translate that to your actual DB?
HTH