[AccessD] List order in listbox

[dw-murphy at cox.net]

Never mind. I got too clever for myself. I forgot that I had some code
behind the form that sets the listbox row source after a combo box updates.
Duh! I created this app a few months ago and the person using it ask for the
sorting. Memory being what it is I forgot how it works so just updated the
row source sql.

Brain isn't getting any better with time.

-----Original Message-----
From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On
Behalf Of dw-murphy at cox.net
Sent: Wednesday, February 15, 2023 10:57 AM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] List order in listbox

Folks,

Have not been doing much Access as I have pretty much fully retired. I am
creating a small Access application for a group I belong to. While some
things take a little longer is seems I have retained most of the basics. One
thing that isn't working is getting a list box to sort properly. The row
source for the list box is a saved query that filters from the ID value of
the form the list box is on. My recollections is the list box reflects the
sorting of its row source, in this case the query.  When I open the query it
sorts properly. The list box is sorting alphabetically on the visible field,
not on the not visible column that it should be. The sort column is
available in the listbox, but has it's column width set to 0. Not sure what
is going on here. 

Doug

-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com