Martin Beney
Registered User.
- Local time
- Today, 15:22
- Joined
- Mar 22, 2007
- Messages
- 27
Hi,
Here's an interesting problem. First though I can find many other ways to solve this problem, its just that I can't get THIS way to work which is odd.
I am using a QueryDef and setting a parameter to set the order by clause and then setting the the ListBox's record set to the querydef.openrecordset.
The result is a populated listbox. But it is not sorted.
I also tried setting the recordset's sort clause. Once again it did nothing.
So has anybody any ideas on how to set the sorting order for a listbox that is populated using a record set?
Martin
Here's an interesting problem. First though I can find many other ways to solve this problem, its just that I can't get THIS way to work which is odd.
I am using a QueryDef and setting a parameter to set the order by clause and then setting the the ListBox's record set to the querydef.openrecordset.
The result is a populated listbox. But it is not sorted.
I also tried setting the recordset's sort clause. Once again it did nothing.
So has anybody any ideas on how to set the sorting order for a listbox that is populated using a record set?
Martin