The Filter property must look like what you would put after the WHERE keyword in SQL. Which field do you want to filter? I suspect you meant to do something like:
Me.Filter = "[MyField] = 'GroupCode ASC'"
Me.Filter = "[GroupCode] = 'ASC'"
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
Posted by: John Viescas <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (10)|