[AccessD] List order in listbox

[jack drawbridge]

Yes Rocky! Ain't that the truth!!

On Wed, Feb 15, 2023 at 7:27 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Agreed. I thought getting old would take longer.
>
> Nice to hear from you.
>
> r
> On Wed, Feb 15, 2023 at 4:24 PM <dw-murphy at cox.net> wrote:
>
> > 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
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>