Solved

Datasheet view form sort by issue

Posted on 2014-01-23
1
598 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 34

Accepted Solution

by:
PatHartman earned 500 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now