sort property in vb recordset

[erez_zi]

Hi,

I'm trying to create a recordset and use the sort proerty, but it fails when opening the recordset for an unspecified error. Here's the code:


private Sub Form_Load()
Dim rst as new ADODB.Recordset

With rst
.Fields.Append "fld1", adBSTR
.Fields.Append "fld2", adInteger
.Sort = "fld1"
.Open
End With
End Sub



WHY ??????