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.
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:
The last resort, in fact, it should be the very first, check the value of Rs("Medical").Value through Visual Basic .NET Debugging