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:
  1. Set rst = New ADODB.Recordset
  2. sql = "SELECT FileInfo.[Comments] FROM FileInfo WHERE FileInfo.FileName = " & selectedFile
  3. rst.Open "UserInfo", cnn, adOpenKeyset, adLockPessimistic, adCmdText
  4. Set rst = cnn.Execute(sql)