Datasheet view form sort by issue

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
SteveL13Asked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.