If Text1.Text = "" And Text2.Text = "" And Text3.Text = "" Then
  MsgBox "请输入查询条件！"
  Exit Sub
End If
If Text1.Text <> "" And Text2.Text = "" And Text3.Text = "" Then
  str = "select * from 会员表 where 姓名='" & Trim(Text1.Text) & "'"
End If
If Text2.Text <> "" And Text1.Text = "" And Text3.Text = "" Then
  str = "select * from 会员表 where 会员卡号='" & Trim(Text2.Text) & "'"
End If
If Text3.Text <> "" And Text2.Text = "" And Text1.Text = "" Then
  str = "select * from 会员表 where 备注='" & Trim(Text3.Text) & "'"
End If

re.Open str, conn, 1, 3
If re.RecordCount = 0 Then
  MsgBox "你要搜索的客户不存在，请核对！"
  Exit Sub
End If
Me.MSFlex1.Rows = re.RecordCount + 1
For i = 1 To re.RecordCount
   For j = 0 To 4
   Me.MSFlex1.Row = i
    Me.MSFlex1.Col = j
    If re(j) = "" Then
    Me.MSFlex1.Text = ""
    Else
    Me.MSFlex1.Text = re(j)
    End If
    Next j
    re.MoveNext
Next i
re.Close

你把你查不到的数据,直接到 ACCESS 里建查询来查询一下,看看能查到不，
如果查不到，那么检查你的查询命令。如果是得到，那检查你生成的SQL 命令。

建议你使用 模糊查询 like 关键字。

我试试like 关键字