Code:
Select * from Table Where MSSV='" & myValue &"'"
where MyValue is the variable that holds the value you are searching for and is a text field. If the field is a numeric field then it would be

Code:
Select * from Table Where MSSV=" & myValue