Problem with Form.OrderBy and ApplyFilter Event

christian123
christian123 used Ask the Experts™
on
Hi,
When I order my records by setting:

frm.OrderBy
frm.OrderByOn=True

this always triggers a ApplyFilter event. Do you have any ideas to avoid the ApplyFilter event?
I can not understand this behaviour at all because OrderBy should work independend of the filtering mechanism ....

MANY THANKS in advance!
Christian
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Have you tried:

frm.OrderBy = "[FieldName]"
frm.OrderByOn = True

I've always had problems applying OrderBy to my forms.  What I do instead is make a query duplicate of the underlying table and establish the sorts there and apply the query as the record source of the form.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial