if there is a "space" on your field/table name, enclosed it in square bracket.
make sure it is the Table name, not the Form name.

Set rs = db.OpenRecordset("select [Email id] from [profile details form updated] where Undergoing MS = '" & Me![MS no] & "'", dbOpenSnapshot, dbReadOnly