To me this looks like an ORDER BY clause rather than a WHERE (filter) clause.
If so, it should be:
Me.OrderBy = "GroupCode ASC"
Me.OrderByOn = True
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: "Graham Mandeno" <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (12)|