There is no Validation Rule (blank). All three values are asigned to string variables.
Option3 SQL string is :

strSQLT = "SELECT tblCombatSquad.[SquadAA], tblCombatSquad.[SquadID] FROM tblCombatSquad " _
& "WHERE tblCombatSquad.[Nationality] = '" & strTargetSide & "';"

Thanks