?
Solved

Datasheet view form sort by issue

Posted on 2014-01-23
1
Medium Priority
?
631 Views
Last Modified: 2014-01-23
I have a form that opens in datasheet view.  Some of the columns can be sorted because the "Sort By" property refers to those fields.

But 4 of the columns aren't "sortable" because they are DLookup fields.

How can I make them sortable like the others?

--Steve
0
Comment
Question by:SteveL13
1 Comment
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 39805049
Most DLookup()s can be replaced by joining to the lookup tables in your RecordSource query.  So, add the lookup tables and select the fields you are "looking up".  Make sure to set the Locked property of these controls to Yes to avoid accidental updates.  Once the column is in the query, you will be able to sort on it.  If the values might be null, use Left Joins so you won't lose "main" records.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…
Suggested Courses
Course of the Month15 days, 10 hours left to enroll

850 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