Why the following code gives an error message
at
<rst.Index = "PrimaryKey">
"Compile error
Method or data member not found"


Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset

Set cnn = New ADODB.Connection
cnn.Open "provider=Microsoft.Jet.OLEDB.4.0;data source = c:\project\vb\access\masters.mdb;"

Set rst = New ADODB.Recordset
rst.Index = "PrimaryKey"
rst.Open "Itemmast", cnn, adOpenKeyset, adLockOptimistic, adCmdTableDirect

rst.Seek "=", Text1.Text
If Not rst.EOF Then
Form1.Text2.Text = rst.Fields(1).Value
End If
rst.Close