[RESOLVED] Filtering recordsets. Help please!

[ginothegodfather]

To filter the recordsets with 2 variables (date and user) i use this code:

Set mrs = New ADODB.Recordset
With mrs
.ActiveConnection = cnn
.Source = "Select * From TABLE"
.Open "select F1,DATE,F3,USER,F5 from TABLE"
End With

mrs.Filter = "DATE='" & txtDate.Text & "' and USER='" & txtUser.Text & "'"

Set MSHFlexGrid1.Recordset = mrs

Now I want to filter recordsets betwen dates. I mean: "from txtData1 to txtData2 and txtUser too". How can i make this? Can anybody help me please? Thnx.