List Box column sequence in incorrect order (1 Viewer)

HelpMoses76

Member
Local time
Today, 01:41
Joined
Sep 17, 2020
Messages
45
When I assign the row source property via code or within properties box for a List Box...the order of the columns is not what I went it to be .Any ideas how to achieve the exact sequence of columns need . please help.

Thanks

Moses
 

Isaac

Lifelong Learner
Local time
Yesterday, 22:41
Joined
Mar 14, 2017
Messages
8,738
They should match the order in which you choose to Select them in the Select query, i.e.:
select col1, col2 from table1
should result in col1 being first lb column col2 being second one. Do they?
 

HelpMoses76

Member
Local time
Today, 01:41
Joined
Sep 17, 2020
Messages
45
Unfortunately that does not help either . it reverses the order . instead of it showing left to right...it shows right to left.
 

Isaac

Lifelong Learner
Local time
Yesterday, 22:41
Joined
Mar 14, 2017
Messages
8,738
See if the attached explanation helps - see the queries and mostly the Form...
 

Attachments

  • Testing 20200917 LB col order.accdb
    512 KB · Views: 93

HelpMoses76

Member
Local time
Today, 01:41
Joined
Sep 17, 2020
Messages
45
Thank you . I will try this again . I suspect I have in the past as well.
 

Users who are viewing this thread

Top Bottom