Painful sex

Has anybody had this happen to them? So this morning my so and me were having foreplay. Both wanted it to go all the way to sex but when he went to go on top I found it so painful that we couldn't even get to sex. I was just crying my eyes out. I don't know if it was because it's the anniversary of my granddads death today or as a result of the yeast infection I had last week. I am due tomorrow so wanted one last session before aunt flow.

He was fantastic with me and just held me but I feel like I've let him down :(. Has anyone else experienced this? And what did you do to overcome this?