Filtered Recordset [RESOLVED]

[JCScoobyRS]

Private Sub rdALL_Click()
    OraRec.Filter = ""
    OraRec.MoveFirst
    varBookmark = OraRec.Bookmark
End Sub

I have a DataGrid bound to OraRec. I filtered it and now I want to eliminate the filter. I set it = "" but the DataGrid doesn't show the results of the unfiltered recordset. What am I doing wrong? Thanks, Jeremy

[brucevde]

I don't use bound controls but I would suspect you need to do a Refresh on the DataGrid.

[JCScoobyRS]

Bruce,
I tried that and it didn't work. Here's the way it works. I have a DataGrid bound to a recordset. When I filter the recordset, it automagically updates the DataGrid. Now, when I set the filter = "", I get one blank row in the DataGrid. I have tried rebinding, I have refreshed and now, I'm out of ideas. Do you have anymore? Thanks, Jeremy

[JCScoobyRS]

Bruce,
I had to "Set DataGrid1.DataSource = OraRec". That seems to be the only thing that works. WOOHOO!!! Thanks for your help, Jeremy