Sorting a filtered form

[mikeal_a@yahoo.com]

Hello,

I am using Access 2010 and have a continous form in with a text box that on exit will filter records:

Me.filter = "TestCaseTitle Like '*" & Me.txtKeyWord & "*'"
Me.FilterOn = True

The filter works fine. I also have buttons in the form header above each column of data that when clicked will alternate between sorting ascending and descending:

'example of button that calls sort
SortTestCaseInfo ("GameName Desc, PriorityID, TestCaseTitle")

Private Sub SortTestCaseInfo(sOrderBy As String)
Me.OrderBy = sOrderBy
Me.OrderByOn = True


End Sub

Both the filtering and sorting work fine on their own. However, If I run the filter first, then attemt to sort, or change any row data the controls do not seem to respond at all. I must put the form into design view and then the sorting works along with ability to change data. Basically, none of the events of the button are firing after the filter is turned on unless I go into design view... When I go back to form view the filter is still set and the sorting (buttons) work great. Any Suggestions.

Thanks,
mike

[rpeare]

Instead of using a filter on your form, try running your form from a query and the items you're putting in your filter apply as a criteria to the query that runs the form.

I'm not exactly sure how filters affect the ability to change data but filters, in my experience, are a pain in the ass and I'd much rather do things with queries.

If you're determined to keep using the filter property is there any chance you could upload a copy of your database for examination (2003 if you can)?