Order BY for listfield in VBA

[MarkWright]

Hello, I have an adp Datenbank and am trying to order my list from A-Z. I am using a query to call my information but the "Order BY :::" does not work in a adp Datenbank. I have also tried to add --> Me.RecordSource = "SELECT * FROM qryTestzycluslist ORDER BY testnr DESC;" --- to my formular when opening but it does not work eather. My problem is that I call all my information from Outlook over a mdb Datenbank and I fill my table in my adp Datenbank. I use a query to filter the users mail and now I need to order the mail so that it is easier to see what mail is wanted.
Does anyone have a Idea ??
Thanks for your help
Mark

 

[MarkWright]

Hi I found it !! if anyone is interested here is the code I use--> Me.lstmails.RowSource = "Select Betreff, Von, An, Inhalt, Erhalten From PBS_Posteingang Where Mitarbeiter = " & G_User & "Order By Von, Erhalten"


have a nice week
Mark