Instead of
if Rs("Medical").Value = "Yes" Or "yes" Then
it should be
If Rs("Medical").Value = "Yes" Or Rs("Medical").Value = "yes" Then
If possible, you should clean up the database.
Minimally, try to look for that script that is responsible for inserting such vague values and make it right.
Good luck.
+++++[round 2]+++++
Based on your feedback, it is entered by some data entry staff in free text form, then good luck to your, it may turn out to be "YES", " yes", "yes ", ...etc. You got it?
In such cases, you can trim the value and see how it turns out:
Rs("Medical").Value.Trim()
The last resort, in fact, it should be the very first, check the value of Rs("Medical").Value through
Visual Basic .NET Debugging[
^].