it means that the rst expects other parameters.
First i'd say open your recordset up then execute your sql query!
i.e
VB Code:
Set rst = New ADODB.Recordset sql = "SELECT FileInfo.[Comments] FROM FileInfo WHERE FileInfo.FileName = " & selectedFile rst.Open "UserInfo", cnn, adOpenKeyset, adLockPessimistic, adCmdText Set rst = cnn.Execute(sql)




Reply With Quote