请教高高手：用SQL语句建立的表，如何使记录指针转到欲想的记录？

loneeyes

Private Sub 备注_Click()
Dim dbs As Database
Dim rst As Recordset
Dim strsql As String
  dbs = curruntdb()
  strsql = "select * from 表1"
  Set rst = dbs.Execute(strsql)
  
此时，若想让rst记录指针跳转到第一个'姓名'字段含有'李'字的记录，该如何操作？

哪位高高手点解点解!

zhuyiwen

Syntax

recordset.{FindFirst | FindLast | FindNext | FindPrevious} criteria

The Find methods have these parts.

Part         Description
recordset: An object variable that represents an existing dynaset- or snapshot-type Recordset object.
criteria:  A String used to locate the record. It is like the WHERE clause in an SQL statement, but without the word WHERE.

================================

rst.FindFirst "姓名 Like '*李*'"

[此贴子已经被作者于2004-1-30 0:25:35编辑过]

loneeyes

非常感谢