如果 UserStatus 是一个多值查找字段，该字段的个人价值（S）的通过 UserStatus.Value 访问，所以你需要使用

  ... WHERE UserStatus.Value =活动...
 

How do you select rows based on a multi-value Lookup field in an Access database?

The below ASP code returns no value when using multi-data column:

<%
Dim Contractors
Dim Contractors_cmd
Dim Contractors_numRows

Set Contractors_cmd = Server.CreateObject ("ADODB.Command")
Contractors_cmd.ActiveConnection = MM_Listings_STRING
Contractors_cmd.CommandText = "SELECT * FROM Contractor WHERE UserStatus = 'Active' AND     AgentID= "& Session("AgentID") 
Contractors_cmd.Prepared = true

Set Contractors = Contractors_cmd.Execute
Contractors_numRows = 0
%>

If UserStatus is a multi-value Lookup field then the individual value(s) of that field are accessed via UserStatus.Value so you'll need to use

... WHERE UserStatus.Value = 'Active' ...