[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Subform Sorting

Posted on 2006-04-14
Medium Priority
Last Modified: 2012-05-05
I'm having trouble sorting my subform by my Date field. The name of the field is in the Order By property. What could be the issue?
Question by:tespinoz06
LVL 77

Expert Comment

ID: 16455222
Hi tespinoz06,
Based on what you have said it sounds ok.
You will have to post the SQL for your subform recordsource.

LVL 39

Accepted Solution

stevbe earned 500 total points
ID: 16455378
Sorting should really be done in the query the subform is bound to but if you only want to do this with the subform properties you may need to programatically turn the OrderByOn = True.

I hope your field name is not really Date ... that is a built in function to Access and may be causing your problems. You can try surrounding it with brackets but it still might not work ...   [Date]

Author Comment

ID: 16473347
this article also helped a little: http://support.microsoft.com/?kbid=207769

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question