Re: [MS_AccessPros] Filter

 

Kevin-

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'"

or

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 

http://www.viescas.com/ 

(Paris, France)

On Jan 26, 2016, at 10:35 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,

The filter I use doesn't work. Please help. Thanks in advance.

Me.Filter = "GroupCode ASC"
Me.FilterOn = True

Best Regards,

Kevin

---

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___